I blogged about this last week:

http://peltiertech.com/WordPress/200...y-series-name/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"davethewelder" wrote in message
...
Hi I am trying to create a Macro which will fomat a stacked Column Chart
according to the column heading in the source data. I have five columns of
data and I would like to assign a colorindex = 3 for the most severe,
being
red, and different colours for the rest according to the company spec.

Can anyone help.

cheers,

Davie