Series Collection Interior color changes

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I am working on a large project with several data series
in a chart. I have used the line of code below in visual
basic to change the color of the data series.

..SeriesCollection(26).Interior.Color = RGB(255, 255, 0)

This works for data series 1-56, however any data series
greater than 56 this line has no effect.

I have also tried using the ".Interior.ColorIndex" with
the same result.

Any ideas?


Thanks!
 
Greg -

You are limited to the 56 colors in the Excel color palette. If you
specify a color using RGB, Excel uses the color in its palette that it
(Excel) thinks is closest. The best you can do is change the workbook's
color palette: Select Options from the Tools menu, and click on the
Colors tab. Select a color and click on the Modify button.

- Jon
 
Back
Top