View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
raymondvillain raymondvillain is offline
external usenet poster
 
Posts: 7
Default looping through series

I need to do the same thing to every series on a chart. Some of my charts
have 8 to 10 series lines drawn on them. I know how to write a loop, but I
don't know what the maximum number of SeriesCollection(?)'s is. I want to do
something like

While [what should the test be?]
ActiveChart.SeriesCollection(?).Border.Weight = 1
Wend

Does this make sense?
--
leave well enough alone