Forecast Vs Actual Chart
Charts and Visualization

Forecast Vs Actual Chart with Safe Zone Range in Excel

In this article, we have created a Forecast Vs Actual Chart with Safe Zone Range. This is a very informative chart wherein you can display that your actual numbers are within the forecast range or not.

We have below given data to create this chart-

Actual and Forecast data
Actual and Forecast data

We have created a below given chart where we have displayed – Forecast, Actual and Safe Zone Range. Safe Zone range is dynamic. It will adjust on the chart automatically. Safe Zone Range is ± given % of the yellow highlighted cell. For example – if we put 10% in yellow highlighted cell and our forecast for a month is 100 then Safe Zone Range will be 90 to 110 for that month.

Forecast Vs Actual Chart
Forecast Vs Actual Chart

 

Click here to download the Practice file-

Watch the 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