Easily create an area chart based on threshold value in Excel

Supposing you have a monthly sales table, now want to create a chart to figure out which month’s sale exceeds the target value and which month’s sale is below the target value, here the threshold value area chart can do you a favor.

In a threshold value area chart, you can not only figure out whether a month’s sale meet the target at a glance, but also can compare all the exceeded sales and the dropped sales by the area sizes to know exactly whether the total sales are up or down in a year.

This article demonstrates the steps of using the Threshold Value Area Chart of Kutools for Excel.

Create a threshold value area chart in Excel

Supposing there is a monthly sales table as the below screenshot, you can do as follows to create a threshold value area chart based on the table data.

1. Enable the feature by clicking Kutools > Charts > Category Comparison > Threshold Value Area Chart.

2. In the Threshold Value Area Chart dialog box, please configure as follows.

Notes:

3. Then click OK in the popping up Kutools for Excel dialog box.

Now the threshold value area chart is complete.