graph title

[Hans Hamers]

Is there a way to use the current filename as "Chart Title" in the "Chart
Options" of a graph ?

 

[Andy Pope]

Hi,

You can link the chart title to a cell. See here for instructions.
http://www.andypope.info/tips/tip001.htm

And the cell to which you link can contain this formula, which will
extract the filename from the returned string. I have split the formula
over 3 lines in case wrapping within the email screws with the formula.

=MID(CELL("Filename",A1),
FIND("[",CELL("filename",A1))+1,FIND("]",
CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

Cheers
Andy

 

[Bernard Liengme]

In some convenient cell enter =MID(LEFT(CELL("filename",A1),
FIND(".",CELL("filename",A1))-1),FIND("[",CELL("filename",A1))+1, 255)
This gets the file name into a cell
Make the chart and add a tile (anything will do)
Click on the tile in the chart, in the formula bar type = and then point to
the cell with the formula given above.
best wishes