reture the range of a chart series
 

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

reture the range of a chart series
 

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



"Bruce" wrote in message
...
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.

Bruce