Show cells that are linked to charts?

B

Barry

Excel 2003
I would like to know if there is a method to show which cells are linked to
charts?
I have a rather large spreadsheet (> 40 worksheets) this spreadsheet has
many charts all on a seperate worksheets. The chart; data series, names,
labels etc. are mostly from two worksheets.
Since I have so many charts referenced to two worksheets keeping track of
which cells are referenced to a specific chart is very time consuming.

Is there a method to highlight linked cells? Then I could add a comment to
each.

Or perhaps you have a better idea.

Thanks
 

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

Top