Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dilbert00
 
Posts: n/a
Default How do I use VBA to change line colors


I have a multi-series 2-D line chart. Each series is a different color,
but these colors appear to be chosen automatically, and are not the
colors I want to use.

I've tried this:

GraphObj.SeriesCollection(2).Interior.Color = RGB(255, 180, 0)

But this generates the error "Unable to set the Color property of the
Interior class."

So, where in the depths of the object model can I go to change the
color of the lines? And if you can tell me that, I'll bet you can also
tell me where to go to change the width or thickness of a line, too.

Any help is very much appreciated.


--
Dilbert00
------------------------------------------------------------------------
Dilbert00's Profile: http://www.excelforum.com/member.php...o&userid=23993
View this thread: http://www.excelforum.com/showthread...hreadid=376141

  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

For a line you would need,

GraphObj.SeriesCollection(2).Border.Color = RGB(255, 180, 0)

and for other formatting try these instead of Color.
.Weight = xlMedium
.LineStyle = xlContinuous

Using the macro recorder is a good way of getting this syntax.

You can change the automatic colours for charts. Use the menu Tools
Options. On the Color tab is a section for chart lines and fills.

Cheers
Andy

Dilbert00 wrote:
I have a multi-series 2-D line chart. Each series is a different color,
but these colors appear to be chosen automatically, and are not the
colors I want to use.

I've tried this:

GraphObj.SeriesCollection(2).Interior.Color = RGB(255, 180, 0)

But this generates the error "Unable to set the Color property of the
Interior class."

So, where in the depths of the object model can I go to change the
color of the lines? And if you can tell me that, I'll bet you can also
tell me where to go to change the width or thickness of a line, too.

Any help is very much appreciated.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
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 do I change multi-line entries to single line entries in Exce. CPOWEREQUIP Excel Worksheet Functions 3 April 14th 05 12:38 AM
How do I change background colors between secondary y axis lines? myhounds Charts and Charting in Excel 2 March 28th 05 01:11 AM
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 1 January 21st 05 04:17 PM
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 0 January 21st 05 03:57 PM
How do I change the colour of/remove the Freeze Panes line in Exce katya_1978 Excel Worksheet Functions 1 January 20th 05 07:17 PM


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

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

About Us

"It's about Microsoft Excel"