Hi,
To get the ranges used by a chart data series use the formula property.
Use this in the immediate window.
?activechart.SeriesCollection(1).formula
=SERIES(,Sheet1!$A$1:$A$5,Sheet1!$B$1:$B$5,1)
See John Walkenbach's page on using a classobject to parse the SERIES
formula.
http://j-walk.com/ss/excel/tips/tip83.htm
Cheers
Andy
Ken Johnson wrote:
I can't figure out the VBA code that will return the address of the
range of data plotted on an embedded chart on say sheet1.
Everything I try just results in the "object does not support this
property or method" error message.
I've been recording macros for clues as well as studying the Object
Browser, all to no avail.
Any clues?
Ken Johnson
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info