Getting the RGB code off of Excel's pre-set Styles (Excel 2007)

[jning]

Hi everyone,

I am using excel 2007 and need to use pie charts for a presentation. My boss insists on using one of the pre-set styles ("Chart Style 11", a lot of shades of blue). However, I need to manually create a legend in powerpoint using text boxes, and I'd like to fill in the text boxes using the RGBs for the pre-set style. However, I cannot find a way to find the RGB codes, in order to get the exact colors. When I go to "format data series" and go to "fill", it is set to automatic, but when I try to go to solid fill in order to extract the RGB code it changes colors on me.

Is there a way to get this in excel or is it in a manual somewhere?

Thanks.

jning

 

[JoeMo]

Click on a data point on the chart>Format Data Series>Marker Fill (the Automatic button will be selected)>Solid Fill>Colors>Custom Tab. The current RGB settings will be seen on this tab. With Excel 2010 I get R=79; G = 129 and B = 189 for Chart Style 11.

 

[jning]

Are you sure?

I am using a pie chart with eight different parts. I was hoping to find a way to get each RGB code for each part of the pie. When I try your method, it changes all the different parts of the pie chart to the same color. Do you happen to know a way around this?

Click on a data point on the chart>Format Data Series>Marker Fill (the Automatic button will be selected)>Solid Fill>Colors>Custom Tab. The current RGB settings will be seen on this tab. With Excel 2010 I get R=79; G = 129 and B = 189 for Chart Style 11.

 

[JoeMo]

Are you sure?

I am using a pie chart with eight different parts. I was hoping to find a way to get each RGB code for each part of the pie. When I try your method, it changes all the different parts of the pie chart to the same color. Do you happen to know a way around this?

Didn't notice it is a pie chart. With the chart selected, double-click any wedge. Then on the Format Data Series dialog box that opens select Fill>Solid Fill>Fill Color Drop Down select More Colors>Custom. The Custom tab will display the RGB values for that wedge. Repeat for other wedges.

EDIT: Sorry, just tried this myself and it will only get you the RGB for what I assume is the base color for the shades of blue.