Easily create an area chart based on threshold value in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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.
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
