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
