graph title
 

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

graph title
 

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

graph title
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Hans Hamers" <Hans wrote in message
...
Is there a way to use the current filename as "Chart Title" in the "Chart
Options" of a graph ?