Easily create a Y-axis threshold segmentation chart in Excel
Kutools for Excel
Boosts Excel With 300+
Supposing you have a range of data, and want to create a chart to analyze which data exceeds a specified threshold and which one does not exceed it, the Y-axis threshold segmentation chart is your best choice. In this tutorial, we introduce the Threshold Value Chart utility of Kutools for Excel to help you easily create a Y-axis threshold segmentation chart in Excel with several clicks only.
Create a Y-axis threshold segmentation chart in Excel
For a monthly sales table as the below screenshot shown, you want to create a chart to figure out which month’s sale exceeds 7800 and which month’s sale does not exceed it, and display the excess or unreached values as well, please do as follows.
1. Select the data range (if the header row of the table is a merged cell, you need to exclude it from the selection), and then click Kutools > Charts > Difference Comparison > Threshold Value Chart.
2. In the Threshold Value Chart dialog box, you need to configure as follows.
Note: If you have selected data in step 1, the corresponding ranges will be outputted in the Axis Labels box and Data range box automatically. Otherwise, please set them as following:
Now the y-axis threshold segmentation chart is created.
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.
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 30 days.