reture the range of a chart series

B

Bruce

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
 
T

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



Bruce said:
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
Click to expand...
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 =
Click to expand...
Worksheets("ASX_Data").Range("A2:A" & endrow & "")
However the A2:A part of the range varies from chart to chart so I want to
Click to expand...
return this as it currently is on the chart andonly update the end row.
 
Top