Pivot Table Graph

[Vanessa Simmonds]

Good Morning, All.

Is there a way to change the colour of the series on a column chart
permantely?

I know how to change but everytime a change one of the variable in the graph
the colours change to the original setup.

Thank you very much for your help.

Best Regards,

Vanessa Simmonds

 

[tpeter]

Good Morning Vaness,

I played with this and the only option I could come up with was running a
macro. If you always have the same number of series this will work fine. I
put it on the charts activate event and it worked fine. Hope this helps, here
is a sample that I made quickly.

ActiveChart.SeriesCollection(4).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
Selection.Shadow = False
Selection.InvertIfNegative = False
With Selection.Interior
.ColorIndex = 17
.Pattern = xlSolid
End With
ActiveChart.SeriesCollection(3).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
Selection.Shadow = False
Selection.InvertIfNegative = False
With Selection.Interior
.ColorIndex = 21
.Pattern = xlSolid
End With
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
Selection.Shadow = False
Selection.InvertIfNegative = False
With Selection.Interior
.ColorIndex = 30
.Pattern = xlSolid
End With
ActiveChart.ChartArea.Select
End Sub