I wish to get the HEX or RBG numbers for the colours that are used in the Excel 2007's chart style 2.
This is the chart style as shown in the sample sheet below. I have used the macro recorder but that just applies activechart.chartstyle = 2
I am really only interested in the colour of the different data series shown on the example. Green, Blue, Purple and Red etc.