Line Chart with RAG Background
Charts and Visualization

RAG (Red, Amber and Green) Analysis Chart in Excel

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.

Data set for chart
Data set for chart

Below is the snapshot to Line chart with dynamic RAG Background color

Line Chart with RAG Background
Line Chart with RAG Background

Click here to download this practice file.

 

Watch step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com