In the chart, right click the below series, and then select the Format Data Series from the right-clicking menu.ģ. Select the source data, and add a line chart with clicking the Insert Line or Area Chart (or Line)> Line on the Insert tab.Ģ. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.Supposing there are two data series in the source data as below screen shot shown, we can easily add a chart and break the chart axis with adding a secondary axis in the chart.

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. 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.

Next, we will highlight the data, Insert a line chart by going to the Insert Tab, and select Insert Line chart.įigure 3 – How to make a break in a graph.

We will set up our data as shown in figure 2įigure 2 – Setting up data to scale break.

We can use this when we have some large or random data in our graph that disrupts its flow.įigure 1 – How to add a break in a graph Insert axis break using a secondary axis in chart

We can make an axis break in a graph when we wish to make precise analysis about particular conditions. How to Add A Break in A Chart Or Graph – Excelchat

Microsoft excel 2011 break in axis