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
--
Barry