Updated Titles (headings) on a chart

L

Leigh

Hi,

I have approx 13 sheets. 1 which carries the data and the other 12 sheets
which have charts. Each of the 12 sheets are individually named. My question:
on each one of the 12 sheets i have a chart with a title (heading) which
matches the sheet name. Is it possible that when I update my sheet name i can
get it to automatically update the title. I do know that you can have Cell
references relating to your headings, however my charts are on seperate
sheets and not on spreadsheets.

Any solution will be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-title multiple MS Project .mpp files at once 0
Creating a Chart on form from selected data in query. 0
Mail Merge Directory Conditional Page Break 0
One extra x axis item that wont go away - can anyone help? 3
Need help modifying code 0
How to display the Chart Name as a Chart Title? 1
External cell reference between two excel worksheets both in One Drive 0
White space above heading inconsistently applied 1

Top