LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 192
Default change series or line color in excel 2007 vba

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
Search this Thread:

Advanced Search
Display Modes

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
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
excel 2007 - change fill color from one color to another okiedokiedoo Excel Discussion (Misc queries) 1 December 30th 07 10:25 PM
how do I change a line series to a column series in excel? Mati Charts and Charting in Excel 1 May 12th 05 09:32 AM
change series color in Excel VB [email protected] Charts and Charting in Excel 0 March 1st 05 06:33 AM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM


All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"