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,