Programmatically determine Chart's data source

[Guest]

I want to loop through all of the embedded charts in a workbook and determine
the name of the source worksheet and the range of cells that make up the data
source for each chart. What's the syntax.

 

[Guest]

Unfortunately, I don't believe you can do this easily. John Walkenbauch has a
method to obtain it from the charts' SERIES formulas. See the second
bulletted item at:

http://www.j-walk.com/ss/excel/odd/odd15.htm

A better way may be to maintain a relationship between charts and chart
series and worksheet indexes.

Regards,
Greg

 

[Steve Drenker]

DR...I recently used John Walkenbach's solution very successfully. See
http://www.j-walk.com/ss/excel/tips/tip83.htm