3. Now, right click the vertical axis and go to format axis. In format axis, enter minimum to 0 and in maximum enter the point after which you want to create the break in the graph. 4. Resize the chart by dragging down the inner handles. 5. Now make a dup

For the many people who do want to create a split y-axis chart in Excel see this example. Jon – I know I won’t persuade you, but my reason for wanting a broken y-axis chart was to show 4 data series in a line chart which represented the weight of four

Supposing there is an extraordinary big data in the source data as below screen shot, we can add a dummy axis with a break to make your chart axis precise enough. 1. To break the Y axis, we have to determine the min value, break value, restart value, and