| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing ChartTypes will not change the color of the Series
I have Excel 2007 and trying to make this compatible with users that
have Excel 2002/2003. I am having a hard time with the code below. When I change a specific series from a stacked chart to a line and then try to change the color, I am not successful. I am successful with changing the chart type, however. 'Create the Average Line .ActiveChart.PlotArea.Select .ActiveChart.SeriesCollection.NewSeries y = .ActiveChart.SeriesCollection.Count .ActiveChart.SeriesCollection(y).Values = "=Sheet2!R" & intRow + 1 & "C2:R" & intRow + 1 & "C" & rst.Fields.Count .ActiveChart.SeriesCollection(y).Name = "=""Average""" .ActiveChart.SeriesCollection(y).Select .ActiveChart.SeriesCollection(y).AxisGroup = 1 .ActiveChart.SeriesCollection(y).ChartType = 4 .ActiveChart.SeriesCollection(y).Interior.Color = RGB(0, 0, 0) I have tried everyhing and I can't figure it out. Any help you can shed will be greatly apprecitated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing font style/size/color/etc for multiple series in a chart? | Charts and Charting in Excel | |||
| help me to change the color of two series in a chart into the same | Charts and Charting in Excel | |||
| Dynamically changing Border-Color of all series() to "0" | Charts and Charting in Excel | |||
| Changing Series Color | Charts and Charting in Excel | |||
| Changing the color of a Series Collection using visual basic? | Charts and Charting in Excel | |||
Threaded Mode
