Forum Discussion

Jon_Needham's avatar
Jon_Needham
Copper Contributor
Mar 10, 2022

Conditional Formatting a stacked column chart in excel

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!

No RepliesBe the first to reply

Resources