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/
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,