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