I have several charts with around 20 different series in each. I would like to standardise the colour of each series based on the series title.
Here's my thinking in terms of the best way to go about it:
1) Based on a default chart (lets call it chart 116) for each series name, get the colour each series is set to in the chart
2) Apply the same series colour to series with the same name in the other charts
So with my default chart - chart 116.
I know how to get the series name for once series and and the colour allocated based on the macro below.
[VBA]
Sub test()
Dim x As String
ActiveSheet.ChartObjects("Chart 116").Activate
x = ActiveChart.SeriesCollection(7).Name
' z = ActiveChart.SeriesCollection(7).Border.ColorIndex
End Sub
[/VBA]
Now I need to do the same for each series in the chart, and then stores the mappings somewhere, and then apply to all other charts in the sheet. Is this easy to do?
Of course, I could do this manually but I am colour blind so looking for a automated solution.
Hope someone can help
Thanks,
HN