Select Range A1:A7, then select Range C1:E7 with holding the Ctrl key, and insert a chart with clicking the Insert Column or Bar Chart (or Column)> Stacked Column.Ĥ. (2) In Cell D2 enter =IF(B2>$B$13,100,NA()), and drag the Fill Handle to the Range D2:D7 (1) In Cell C2 enter =IF(B2>$B$13,$B$13,B2), and drag the Fill Handle to the Range C2:C7 We need to refigure out the source data as below screenshot shown: In our example we get four values in the Range A11:B14.Ģ.
To break the Y axis, we have to determine the min value, break value, restart value, and max value in the new broken axis.
Using Kutools for Excel's Truncate the Y-axis Chart (3 steps)īreak axis by adding a dummy axis in chart using built-in Excel functionalities (16 steps)ġ. Using built-in Excel functionalities (16 steps). Please select either of the below methods to follow the corresponding instructions. Supposing there is an extraordinary big data in the source data as below screenshot shown, we can add a dummy axis with a break to make your chart axis precise enough. Then you will see there are two Y axes in the selected chart which looks like the Y axis is broken. Tip: If you are using Excel 2007 or 2010, right click the primary vertical axis in the chart and select the Format Axis to open the Format Axis dialog box, click Number in left bar, type 0 into the Format Code box and click the Add button, and close the dialog box.) In the Format Axis pane, type 160 into the Maximum box in the Bounds section, and in the Number group enter 0 into the Format Code box and click the Add button, and close the pane. In the chart, right click the secondary vertical axis (the right one) and select Format Axis from the right-clicking menu.ĥ. In the opening Format Data Series pane/dialog box, check the Secondary Axis option, and then close the pane or dialog box.Ĥ. 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.Ģ. 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.
0 kommentar(er)
