RAG (Red, Amber and Green) Analysis Chart is very useful to analyze the performance. We have designed this chart using Stacked column chart and Line chart. You can change the background color range by just changing numbers on excel.
Below is the data set which we have used for this chart. We have taken 3 support columns here.
Below is the snapshot to Line chart with dynamic RAG Background color
Click here to download this practice file.