Thread
:
Programmatically determine Chart's data source
View Single Post
#
3
Posted to microsoft.public.excel.programming
Steve Drenker[_3_]
external usenet poster
Posts: 5
Programmatically determine Chart's data source
DR...I recently used John Walkenbach's solution very successfully. See
http://www.j-walk.com/ss/excel/tips/tip83.htm
in article
, Greg Wilson
at
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
Reply With Quote
Steve Drenker[_3_]
View Public Profile
Find all posts by Steve Drenker[_3_]