View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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.