Conditional Formatting a stacked column chart in excel

Occasional Visitor

I have created a stacked column chart to display my data, but want it to automatically RAG rate each column depending on the score displayed. At the moment I am creating the chart, then changing each column separately to reflect the Red/Amber/Green status.

 

I have formatted the data cell, but want to do this to the chart. Is there an automated way of doing this?

 

NB - please make any instructions VERY simple!

0 Replies