I
Ian R
Hi
I'm using Excel 2003
I have several charts on a worksheet.
At the end of each month I copy the sheet to become the first worksheet
in the workbook, delete the data and rename the sheet for the following
month.
All my charts have a chart title e.g "Total income for April 2010". The
sheetname is April 2010. When I copy this sheet to become "May 2010" I
then have to manually edit all the chart titles on that sheet.
I wondered if there is a way to reference the sheetname in the chart
title so that when I rename the sheet the chart titles automatically
update.
Thanks for your time.
Ian
I'm using Excel 2003
I have several charts on a worksheet.
At the end of each month I copy the sheet to become the first worksheet
in the workbook, delete the data and rename the sheet for the following
month.
All my charts have a chart title e.g "Total income for April 2010". The
sheetname is April 2010. When I copy this sheet to become "May 2010" I
then have to manually edit all the chart titles on that sheet.
I wondered if there is a way to reference the sheetname in the chart
title so that when I rename the sheet the chart titles automatically
update.
Thanks for your time.
Ian