We will right-click on the Secondary vertical axis and select Format Axis from the drop-down menu Figure 8 How to add a break in excel graph. We will close the dialog box Figure 7 How to break y axis in excel. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. In the Format Data Series dialog box, we will mark the Secondary Axis option Figure 6 Split axis in excel. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.
We will go to the Number group, we will pick the Custom Category and type =500]0 into the Format code box and click the Add button to close the pane.įigure 16 – How to make a break in a graph Instant Connection to an Excel Expert.We will click on Number in the left bar and enter the code 0 in the Format Code box and click on the Add button to close the dialog box.įigure 11 – How to insert chart breaks In Excel 2013 or higher Format Axis dialog box, we will go to the Bound section and type 200 into the Maximum Boxįigure 12 – How to scale break in Excel 2016.Then, we will type 200 into the box.įigure 9 – How to insert excel axis break We will click on Axis Option in the left bar and mark the Fixed option behind the Maximum.We will right-click on the Secondary vertical axis and select Format Axis from the drop-down menuįigure 8 – How to add a break in excel graphĭepending on our Excel Version, we will proceed as follows:.In the Format Data Series dialog box, we will mark the Secondary Axis option.In the chart, we will right-click below the series and select Format Data Series.