Pivot Table Graph

  • Thread starter Vanessa Simmonds
  • Start date
V

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top