Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart SeriesCollection Names
Is there a way to check to see if a certain series has been displayed on a
chart? I have several data sets that can be plotted depending on a user selection. I have 5 data sets to be plotted on the secondary Y axis, one of which has a high maximum scale value. I want to check to see if this series has been plotted and if so, delete it before plotting the others. It may not really matter since the larger scale series will simply disappear off the screen when the lower axis scale is set. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart SeriesCollection Names
If you know where the source data is locted you can get each of the series
source data range and then use intersect to see if the series source address falls into the range where the data is located. I can help if this is the method you want to use. "EPL" wrote: Is there a way to check to see if a certain series has been displayed on a chart? I have several data sets that can be plotted depending on a user selection. I have 5 data sets to be plotted on the secondary Y axis, one of which has a high maximum scale value. I want to check to see if this series has been plotted and if so, delete it before plotting the others. It may not really matter since the larger scale series will simply disappear off the screen when the lower axis scale is set. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart SeriesCollection Names
Dim srs As Series
For Each srs In ActiveChart.SeriesCollection If srs.Name = "Name of series I want to delete" Then srs.Delete End If Next - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ EPL wrote: Is there a way to check to see if a certain series has been displayed on a chart? I have several data sets that can be plotted depending on a user selection. I have 5 data sets to be plotted on the secondary Y axis, one of which has a high maximum scale value. I want to check to see if this series has been plotted and if so, delete it before plotting the others. It may not really matter since the larger scale series will simply disappear off the screen when the lower axis scale is set. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart SeriesCollection Formula | Excel Discussion (Misc queries) | |||
Chart: range info from seriescollection? | Charts and Charting in Excel | |||
Chart: range info from seriescollection? | Excel Programming | |||
Formatting a new seriescollection in a chart object | Excel Programming | |||
Adding to the SeriesCollection of a chart object in VB6 | Excel Programming |