LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA with EXcel 2000 and series line colors

I am unable to set the line colors of a chart object with
multiple series.

For Each series in chart.SeriesCollection
series.Interior.Color = RGB(0,0,0)
Next

Error message reads "Unable to set the Color property of
the Interior class".

The chart is simply an xy scatter with multiple series
created and displayed properly but each series has a
different color. I want all series to be black.

 
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
Update line chart series colors Apple Ling Charts and Charting in Excel 0 November 2nd 10 06:48 AM
Varying colors on a line chart with multiple series LKP Charts and Charting in Excel 2 September 17th 08 03:23 PM
Repeating colors in Excel 2000 DennyB Excel Worksheet Functions 0 January 17th 07 03:00 PM
How can you get more colors for a document in Excel 2000? boxesss Excel Discussion (Misc queries) 1 March 7th 06 12:22 AM
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


All times are GMT +1. The time now is 10:03 AM.

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"