reture the range of a chart series

[Guest]

Hopw do you return a chart series
I guess its something along the line of

MsgBox (ActiveChart.SeriesCollection(1).Range.Address

but not quite right

Just in case im going about this the wrong way I am trying to update the range based on a variable I have determined as the end row of a serie

ie
endrow = (Worksheets("Data").Range("A1").End(xlDown).Row
ActiveChart.SeriesCollection(l).XValues = Worksheets("ASX_Data").Range("A2:A" & endrow & ""

However the A2:A part of the range varies from chart to chart so I want to return this as it currently is on the chart andonly update the end row

Bruc

 

[Tom Ogilvy]

Perhaps this page from John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip83.htm
A Class Module to Manipulate a Chart SERIES

--
Regards,
Tom Ogilvy

Hopw do you return a chart series.
I guess its something along the line of

MsgBox (ActiveChart.SeriesCollection(1).Range.Address)

but not quite right.

Just in case im going about this the wrong way I am trying to update the

range based on a variable I have determined as the end row of a series

ie
endrow = (Worksheets("Data").Range("A1").End(xlDown).Row)
ActiveChart.SeriesCollection(l).XValues =

Worksheets("ASX_Data").Range("A2:A" & endrow & "")

However the A2:A part of the range varies from chart to chart so I want to

return this as it currently is on the chart andonly update the end row.