How to change axis values on excel pivot chart

#How to change axis values on excel pivot chart how to
#How to change axis values on excel pivot chart series

In the Axis label range box, do one of the following: In the Select Data Source dialog box, under Horizontal (Categories) Axis Labels, click Edit. On the Design tab, in the Data group, click Select Data. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the horizontal (category) axis. In the chart, click the horizontal axis, or do the following to select the axis from a list of chart elements: Note Changes that you make on the worksheet are automatically updated in the chart. On the worksheet, click the cell that contains the name of the label that you want to change. You can change the text of category labels on the worksheet, or you can change them directly in the chart.Д¬hange category label text on the worksheet Tip You can also change the horizontal alignment of axis labels, by clicking the axis, and then click Align Left, Center, or Align Right on the Home toolbar. In the Custom angle box, select the degree of rotation that you want. In the Text direction box, click the text orientation that you want. In the Vertical alignment box, click the vertical alignment position that you want. Under Text Box, do one or more of the following: In the Format Axis dialog box, click Text Options. This displays the Chart Tools, adding the Design and Format tabs. On a chart, click the axis that has the labels that you want to align differently, or do the following to select the axis from a list of chart elements: You can also change the amount of space between levels of labels on the horizontal (category) axis. When you have multiple-level category labels in your chart, you can change the alignment of all levels of labels. You can change the alignment of axis labels on both horizontal (category) and vertical (value) axes. Type a larger number if you want more distance between the label and the axis.Д¬hange the alignment and orientation of labels Tip Type a smaller number to place the labels closer to the axis.

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.

#How to change axis values on excel pivot chart series

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.

#How to change axis values on excel pivot chart how to

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.