Easily create a Y-axis threshold segmentation chart in Excel

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:

2.1) In the Axis Labels box, please change or select the axis labels data;
2.2) In the Data range box, please change or select the data to analyze if they exceed a set threshold;
2.3) In the Y-axis threshold box, enter or select the threshold value;
2.4) Click the OK button. See screenshot:

Now the y-axis threshold segmentation chart is created.


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