Automatic chart colours

[Nige Danton]

OSX, Excel for Mac 2003: I have a spreadsheet which charts the score of 50
people of different nationalities. Column A contains the individual names,
column B the score and column C the nationality. The chart is a column chart.
I would like to format the colour of the chart columns to be the same colour
for the same nationality e.g. all Italians would be green etc.

I could manually set the colours - but is there a way to do it automatically
similar to conditional formatting of cells?

Many thanks for any help.

 

[Michael.Tarnowski]

OSX, Excel for Mac 2003: I have a spreadsheet which charts the score of 50
people of different nationalities. Column A contains the individual names,
column B the score and column C the nationality. The chart is a column chart.
I would like to format the colour of the chart columns to be the same colour
for the same nationality e.g. all Italians would be green etc.

I could manually set the colours - but is there a way to do it automatically
similar to conditional formatting of cells?

Many thanks for any help.

Hi Nigel,

use a helper column in your chart data source to define Excel's
ColorIndex and then use one of Jon Peltier's VBA macros:

* VBA Conditional Formatting of Charts by Value:
http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-value/
* VBA Conditional Formatting of Charts by Series Name:
http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-series-name/

Excel displays only 56 different colors. For more information on Color
Palette and the 56 Excel ColorIndex Colors see http://www.mvps.org/dmcritchie/excel/colors.htm.

Hope that helps
Have a nice day, cheers
Michael

 

[Nige Danton]

use a helper column in your chart data source to define Excel's
ColorIndex and then use one of Jon Peltier's VBA macros:

* VBA Conditional Formatting of Charts by Value:http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts...
* VBA Conditional Formatting of Charts by Series Name:http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts...

Excel displays only 56 different colors. For more information on Color
Palette and the 56 Excel ColorIndex Colors seehttp://www.mvps.org/dmcritchie/excel/colors.htm.

Hope that helps

Many thanks - I'll check it out