Automatic chart colours
 

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

Automatic chart colours
 

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

Automatic chart colours
 

On Oct 6, 3:12*am, "Michael.Tarnowski" wrote:

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

--
Nige Danton