Conditional Formatting a stacked column chart in excel

Copper Contributor

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