Programmatically determine Chart's data source

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

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




"drussell" wrote:

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

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


in article 815F422F-5679-421F-984B-9F33689E07EF@microsoft.com, Greg Wilson
at GregWilson@discussions.microsoft.com wrote on 3/3/06 7:47 PM:

> 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
>
>
>
>
> "drussell" wrote:
>
>> 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.
>> --
>> dr