how to add a secondary axis in mac excel 2013

To change the placement of axis labels, in the Label distance from axis box, type the number that you want. Tip Type 1 to display a label for every category, 2 to display a label for every other category, 3 to display a label for every third category, and so on. To change the interval between axis labels, under Interval between labels, click Specify interval unit, and then in the text box, type the number that you want.

Under Axis Options, do one or both of the following: On the Format tab, in the Current Selection group, click Format Selection.

On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the axis that you want to select. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On a chart, click the horizontal (category) axis that you want to change, or do the following to select the axis from a list of chart elements: For more info on what axes are and what you can do with them, see All about axes.Ĭhange the number of categories between labels or tick marks The following describe how you can modify your charts to add impact and better convey information.

Radar charts do not have horizontal (category) axes, and pie and doughnut charts do not have any axes. 3-D column, 3-D cone, or 3-D pyramid charts have a third axis, the depth axis (also known as series axis or z axis), so that data can be plotted along the depth of a chart. For information about how to change to the scale, see:Ĭhange the scale of the horizontal (category) axis in a chartĬhange the scale of the vertical (value) axis in a chartĬhange the scale of the depth (series) axis in a chartĬharts typically have two axes that are used to measure and categorize data: a vertical axis (also known as value axis or y axis), and a horizontal axis (also known as category axis or x axis).

Important: This article does NOT cover changing the scale of chart axes.

How to add a secondary axis in mac excel 2013