Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
Register  \/ 


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.

2.1) Axis Labels: Select the cell range you will display as the axis labels in the chart;
2.2) Series Values: Select the cells containing the series values;
2.3) Y-axis threshold: Select the cell containing the threshold value, or manually enter the threshold value to the box.
2.4) Click OK. See screenshot:


1) A dynamic threshold line will be created if selecting the cell containing the threshold value, and the line will be moved up or down in the chart automatically when changing the threshold value.
If manually enter the threshold value, you will get a fixed threshold line in the chart.
2) Click the Example button in the dialog to open the sample workbook of this feature.

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

Now the threshold value area chart is complete.

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.