A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

change series or line color in excel 2007 vba



 
 
Thread Tools Display Modes
  #1  
Old January 24th, 2008, 07:34 PM posted to microsoft.public.excel.charting
nick
external usenet poster
 
Posts: 642
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???
  #2  
Old January 24th, 2008, 08:28 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default change series or line color in excel 2007 vba

This works:

objSeries.Border.Color = RGB(255, 127, 0)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" wrote in message
...
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???



  #3  
Old January 24th, 2008, 08:38 PM posted to microsoft.public.excel.charting
nick
external usenet poster
 
Posts: 642
Default change series or line color in excel 2007 vba

Thanks!! That worked. One more question. Do you happen to know why the
border object does not show up when using intellisense in the VBA window of
Excel 2007? That makes it seem as though the border object has been removed
from the 2007 object model.

"Jon Peltier" wrote:

This works:

objSeries.Border.Color = RGB(255, 127, 0)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" wrote in message
...
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???




  #4  
Old January 24th, 2008, 08:52 PM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default change series or line color in excel 2007 vba

Hi,

In VBE press F2 to display object browser. Right click and pick Show
Hidden Members. Border is now there.

Also did you notice how Jon's suggested work around then makes your line
of code work! If you step through the code you should see the line go
black and then Orange, or what ever your colour is.

objSeries.Border.Color = RGB(0, 0, 0)
objSeries.Format.Line.ForeColor.RGB = RGB(255, 127, 0)

Cheers
Andy

Nick wrote:
Thanks!! That worked. One more question. Do you happen to know why the
border object does not show up when using intellisense in the VBA window of
Excel 2007? That makes it seem as though the border object has been removed
from the 2007 object model.

"Jon Peltier" wrote:


This works:

objSeries.Border.Color = RGB(255, 127, 0)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" wrote in message
...

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???





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #5  
Old April 6th, 2010, 02:31 PM posted to microsoft.public.excel.charting
Karen
external usenet poster
 
Posts: 1,223
Default change series or line color in excel 2007 vba

Hello Nick,

I am new to using Macros in Excel and am trying to set the colour of a
marker depending on its value. For example: if the value in the table is less
than 4 the colour is red, if between 4 and 7 it should be yellow and if
between 7 and 10 the value is green.
Have you assigned colours to markers based on this type of criteria?
Would you have a sample piece of code that could help me out?

Thanks,

Karen

"Nick" wrote:

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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.