| 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 |
| 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 | |||
Threaded Mode
