(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. 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.ġ. Then you will see there are two Y axes in the selected chart which looks like the Y axis is broken.
![how to add a secondary axis in mac excel 2013 how to add a secondary axis in mac excel 2013](https://erc.barnard.edu/sites/default/files/inline-images/ca%203.jpeg)
How to add a secondary axis in mac excel 2013 code#
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.
![how to add a secondary axis in mac excel 2013 how to add a secondary axis in mac excel 2013](https://www.indezine.com/products/powerpoint/learn/chartsdiagrams/images/add-sec-axis-ppt2011-08.jpg)
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.Ģ.
![how to add a secondary axis in mac excel 2013 how to add a secondary axis in mac excel 2013](https://www.exceldemy.com/wp-content/uploads/2018/06/add-secondary-axis-in-excel-15.png)
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.