how to add a secondary axis in mac excel 2013

In above Chart, the blue bars represent Monthly Sales ($) and the tiny Orange bars represent Profit Margins (%). Your final result should look like below, showing the break in the axis.When this type of mixed data is used to create a Bar Chart in Excel, we end up with a Chart that does not represent the complete information. Note 2: Click Delete for the Gap and the other Y Axis Select the Labels that you want the Y Axis to show.For Series X Values, Select Data under XPos. For Series called “For Broken Y Series”, click boxĥ. For Series Value, select value under YPosĨ. For the Series Name, select “For Broken Y Series”ĥ. Labels: Create the Axis that you would like to show with the break in itĤ.Change Shape Fill & Shape Outline to No FillĬreate a table with the following information: Click on Middle Portion (This will be the Split)ģ.Hold down Control and highlight data for Before, Break, and After.125 signifies how large the break isĪfter: =IF(C35>$C$52,C35-$C$51-1,NA()) This is how much of the axis after the break will appear Create a Table for the Max Number, where the new axis will Restart, where the axis will Break, and the Min numberīefore: = MIN($C35,$C$52) Finding the minimum value between the Actual Item Sold and the Breakīreak: =IF(C35>$C$52,125,NA()) Finding which items will go after the break.Next to the original data, add a column for Before, Break, and After.Instead, we want to show a break in the axis so that we can show the graphs easier. If you have data that has a large swing in the numbers, the graph doesn’t always show it well. Decrease the Minimum Axis to bring this line to the top of the graph (increase it in your trying to bring it to the top of the graph)

Increase the Maximum Axis to bring this line to the bottom of the graph (decrease it in your trying to bring it to the top of the graph)Ĥ. Check one of the Series for Secondary Axisģ. We’ll start with the example data below.ĥ. In this tutorial, we’re going to show how to create a graph with a secondary axis.

Return to Charts Home Break Chart Axis – Excel Create, Save, & Use Excel Chart Templates

How to add a secondary axis in mac excel 2013