Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that changes colors in a bar chart. The following code worked
in Excel XP. Sheets("Chart").SeriesCollection(1).Interior.Color Index = 5 This command crashes Excel 2007, and I've noticed that the ColorIndex property does not ever appear to be a property of the SeriesCollection object in Excel 2007. Does anyone know how to control chart colors in Excel 2007? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Excel 2007 chart to Word 2007 - only half of it shows | Excel Discussion (Misc queries) | |||
Cannot insert Chart in Excel 2007 and all other Office 2007 applications | Charts and Charting in Excel | |||
SeriesCollection - Incorrect ColorIndex Assigned to Chart | Charts and Charting in Excel | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
colorIndex listing for Chart with autoformat settings | Charts and Charting in Excel |