In EXCEL 2007:
I create a pie chart using Insert Charts.
The chart is created using the default MS Office Theme.
If I then select an individual pie slice and Format data point the 'Fill'
is set to Automatic. When I select 'Solid fill' to try and get the RGB
values for that pie slice the color changes to a different color!

I'm trying to set up a macro to select a data series and extract the RGB
values for that data series.
The RGB values would then appear in a message box.

Thanks.

Mike