Auto chart colouring

[Taylor86]

I have a bar chart that shows percentages of work completed for each process undertaken, these processes then have a ragging to show where they are to target.

so above 85% is green
between 85% - 80% is amber
and below 80% is red

I was wondering if there is any vb code or a way of automating the chart so that the colours of the bars change when the percentage moves between the target.

Is this possible.

Thanking in advance of your help.

[Andy Pope]

Usual way is to chart multiple series based on conditional formula. Each series is coloured to reflect the RAG.

Search for Conditional charts