Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read series values range of a chart | Charts and Charting in Excel | |||
How to dynamically change the series range of a chart ? | Charts and Charting in Excel | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
How do I use a Defined Name range for a value series in a chart? | Charts and Charting in Excel | |||
need help updating chart (series in dynamic range) | Charts and Charting in Excel |