On Oct 4, 1:34*pm, Nige Danton wrote:
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.
--
Nige Danton
email: swop the obvious for g_m_a_i_l

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...arts-by-value/
* VBA Conditional Formatting of Charts by Series Name:
http://peltiertech.com/WordPress/vba...y-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