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!
