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