Note: The other languages of the website are Google-translated. Back to English
English English

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:

Notes:

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 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

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

Designed for Excel(Office) 2021, 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

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations