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:

Now the y-axis threshold segmentation chart is created.