Excel: Break Y-Axis - Display Chart Properly

If you work with extreme values in your charts, you may not be able to display all values as you need for your purposes. Therefore, we will show you how to interrupt the Y-axis and thereby fix the problem.

How to break the Y-axis in Excel

Breaking the Y-axis is a useful way to display charts in the right style. By doing so, you do not change the values themselves, but merely adjust the display.

1. First, create a table and use the MAX formula, thus finding the maximum values and then dividing by two. This is necessary so that the Y-axis can be divided in the middle.
2. Now create a column chart with the desired data series. The table serves for this as a starting point for your chart.
3. Change the scaling from the point where you want to make the break.
4. Now use the formula to make a column chart. You can see that the maximum values that could distort the values are hidden.

Is there a simpler alternative?

To invest less work, you can also use a logarithmic axis in Excel. Alternatively, you can assign the values that prevent you from getting a correct plot to the secondary axis. Dadurch verhindern Sie auch, dass die Darstellung im Säulendiagramm nicht Ihren Bedürfnissen entspricht.