Posted to microsoft.public.excel.programming

external usenet poster

Posts: 671

Excel 2007 Chart SeriesCollection(1).Interior.ColorIndex

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.Colo rIndex = 5

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 Chart colorindex?	Jay	Excel Programming	8	December 14th 09 11:11 AM
SeriesCollection - Incorrect ColorIndex Assigned to Chart	Bob Barnes	Charts and Charting in Excel	11	July 2nd 09 12:02 AM
Use of Interior.ColorIndex	liquidhot	Excel Programming	4	June 27th 05 07:22 PM
Cell.interior.colorindex - does not work in Excel 97	Ian[_13_]	Excel Programming	10	April 5th 05 07:28 PM
Testing for Interior.ColorIndex	JeffBo	Excel Programming	7	May 17th 04 09:41 PM

All times are GMT +1. The time now is 03:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us