Forum Discussion
Jon_Needham
Mar 10, 2022Copper Contributor
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