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