Hi All

Apologies if this has been asked before.

I'm having trouble setting up the footer for a chart I generated using VBA.

I want to setup the left footer so that it shows the worksheet name on it i.e. putting "&[Tab]" in the footer setup part of the page setup options or using
ActiveChart.PageSetup.LeftFooter = "&A"
in VB.

Say the sheet is called "Sheet 1". If I set up the chart as described I get "Sheet 1 Chart 1" in the footer.

Does anyone have any idea what to do to the chart to change the "Chart 1" to something more descriptive e.g. "Stack Chart" (either directly or in VB)

Alternatively does anyone know what I can do to just have "Sheet 1" displayed?

Thanks!