Formatting Charts according to field heading

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

I blogged about this last week:

http://peltiertech.com/WordPress/20...by-series-name/

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


"davethewelder" <davethewelder@discussions.microsoft.com> wrote in message
news:092E35AC-ED53-420D-AD67-295D8993F1BB@microsoft.com...
> 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