Formatting Charts according to field heading

  • Thread starter Thread starter davethewelder
  • Start date Start date
D

davethewelder

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
 
Back
Top