Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA with EXcel 2000 and series line colors
Hi Ed,
Probably because the line doesn't have a interior but a Border. revised code: For Each Series In ActiveChart.SeriesCollection Series.Border.Color = RGB(0, 0, 0) Next On a personal note, I would use variable names that aren't the same as VBA object types. Using Series could get very confusing. Ed Ulle wrote: 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. -- Cheers Andy http://www.andypope.info |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA with EXcel 2000 and series line colors
Andy, Thanks, it worked. I would never have associated Border with the line series. I would think it was the chart border. Ed *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update line chart series colors | Charts and Charting in Excel | |||
Varying colors on a line chart with multiple series | Charts and Charting in Excel | |||
Repeating colors in Excel 2000 | Excel Worksheet Functions | |||
How can you get more colors for a document in Excel 2000? | Excel Discussion (Misc queries) | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |