Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I've done this hundreds of times in 2003, but in 2007 I'm hitting some snags.
I think it has to do with the chart styles found in excel 2007. I'm trying to change the color of a series in my line graph using the following code: Set ch = Worksheets("Chart").ChartObjects(1) Set objSeries = ch.Chart.SeriesCollection(1) objSeries.Format.Line.ForeColor.RGB = RGB(255, 127, 0) But, this isn't working at all. Nothing is happening to the line. I'm able to do other things to the series, such as change the marker style, the marker color, the line style, but not the line color. Any ideas??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
change series color in Excel VB | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |