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