Excel 2007 Chart SeriesCollection(1).Interior.ColorIndex

J

Jay

I thought I had posted this already, but can't find it. Sorry if it's a
duplicate. I have the following code that was written in Excel 2003. Every
time I run it in Excel 2007 it crashes. I can't find anything about changing
the colors of a series in an Excel 2007 chart. Also, when I try to record a
macro to change the chart colors to gain insight, nothing gets written to the
macro regarding the color change. Help!

Sheets("Chart1").SeriesCollection(1).Interior.ColorIndex = 5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Chart Colors 3
Excel 2007 Chart colorindex? 8
Excel 2007 chart question 0
SeriesCollection(2).Formula returns formula for series 1 1
Putting the series 1 and series 2 titles from a worksheet 0
DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003) 0
How to Expose SeriesCollection? 0
SeriesCollection - Incorrect ColorIndex Assigned to Chart 11

Top