Easily create an area chart based on threshold value in Excel
Kutools for 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.
3. Then click OK in the popping up Kutools for Excel dialog box.
Now the threshold value area chart is complete.
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.
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.