Break Chart Y Axis

This post will guide you how to break the Chart Y axis in an Excel worksheet. How do I make a chart with a break Y axis in Excel.

Break Chart Y Axis


For example, Assuming that you have the data in a range (B2:B5) from 10-50 and another range (C2:C5) from 60-90. You have create a line chart based on the data in your worksheet. And now you want to break the Y-axis in the existing chart. How to achieve it. Just do the following steps:

#1 select the range of cells A1:C5 as the source data of the chart.

break chart axis1

#2 go to INSERT tab, click 2-D Line button under Charts group to create a Line chart.

break chart axis2

#3 right click Data Series at the bottom of the chart, select the Format Data Series from the drop-down menu list.

break chart axis3

#4 select the Secondary Axis radio button in the SERIES OPTIONS section under Format Data Series pane.

break chart axis4

#5 the current chart added one more Y-Axis and it also called the secondary vertical axis.

break chart axis5

#6 right click on the secondary Y axis and select the Format Axis from the drop down list.

break chart axis6

#7 under the Format Axis pane, type the number 50 into the Maximum box, and type the [<=35] 0;;; into the Format Code text box in the Number section, and click Add button.

break chart axis7

#8 right click on the primary Y axis in the chart, and select the Format Axis from the drop down list. Type the [>=60]0;;; into the Format Code text box in the Number section, and click Add button.

break chart axis8

break chart axis9

#9 you will see that the chart Y axis has been broken in your current chart.

break chart axis10

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar