Broken Line Graph Excel. Describe the trends you see in the data. Figure 3 How to make a break in a graph.
2 go to INSERT tab click 2-D Line button under Charts group to create a Line chart. Figure 1 How to add a break in a graph. There is no preference option to ensure all data points are connected automatically by excel when a scatter or line chart is created.
On the Format Data Series pane go to Fill.
IF SUM range 0NA SUM range Note range is the cell range that is outside the cell range for the Line chart. Next we will highlight the data Insert a line chart by going to the Insert Tab and select Insert Line chart. Line Chart Question - break in line for blank cells JonPugh you need to tell Excel what to do with NA cells. Figure 2 Setting up data to scale break.
