View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ulle Ed Ulle is offline
external usenet poster
 
Posts: 1
Default VBA with EXcel 2000 and series line colors

I am unable to set the line colors of a chart object with
multiple series.

For Each series in chart.SeriesCollection
series.Interior.Color = RGB(0,0,0)
Next

Error message reads "Unable to set the Color property of
the Interior class".

The chart is simply an xy scatter with multiple series
created and displayed properly but each series has a
different color. I want all series to be black.