Link to home
Start Free TrialLog in
Avatar of marknlynn3
marknlynn3Flag for United States of America

asked on

How to determine RGB values for default colors in Excel 2007 column chart

I created a column chart letting Excel automatically choose the column colors.  I like the colors, but would like to change the order of the colors in the chart.  I can't find a way to determine the RGB values for these automatic colors so that I can manually change them.  When I try to look up the RGB values for a data series the column color is changed to blue.  Here's the procedure I use to try to look up the RGB values: Right click on the data series in the chart, select format data series, select fill, then choose solid fill.  At this point the color is automatically changed to blue.  If the color hadn't changed to blue, the next steps I would have chosen would be: click on the drop down arrow for the color palette, select more colors, and then write down the RGB values so that I could change a different series to that color.  Any help in finding a list of default colors and associated RGB values or a way to determine the values in Excel 2007 would be appreciated.
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Hello makrnlyn,

select the data series, open the format dialog, change the Fill color from Automatic to Solid Fill, then click the color drop-down arrow and select More colors. On the Custom tab of the Colors dialog you can read the RGB values.

cheers, teylyn
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marknlynn3

ASKER

Thanks cyberkiwi.  Love the solution and your username.