Show cells that are linked to charts?
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 |
All times are GMT +1. The time now is 07:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com