Excel chart - how to assign the file name in the chart title?

[Guest]

How do you assign the Excel file name automatically in the chart of the file.

We are developing a templete file. Each file has 5-10 charts and we would
like to have the chart title to include the file name.

We are familiar with the header code "&[file]" but it does not work in the
title.

Thank you,

 

[Ed Ferrero]

Hi TGreen,

Put this formula somewhere on the worksheet. =CELL("filename",A1)
This will return the full path\filename.

Then select the chart, type = and select the cell withthe formula.
That will build a textbox with the filename in the chart.

Ed Ferrero
http://edferrero.m6.net/