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.