Auditing and graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to tell if a cell is being used in any graph in my
workbook. The standard <Audit> <Show dependants> does not seem to concider
Graphs as dependents (Help specifically talks about dependent "cells" in the
auditing write up)

Is anyone aware of a built in method for determining whther a cell is used
in a chart, or does anyone have a recomended macro I can build on?
 
You are right in that the 'Show Dependents' doesn't consider graphs as
dependents. In fact, there is no easy way to find all the cell
references in a workbook. As far as graphs go, even if you are not
using a data label (or textbox) linked to cells, you would still have to
parse the content of the SERIES formula associated with each individual
series of each chart in the workbook. To help you get started see John
Walkenbach's http://j-walk.com/ss/excel/tips/tip83.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Back
Top