You can change the axis position in a pivot chart, specifically the horizontal axis, by adjusting its crossing point.
Here's how:
- Select the Axis: Click on the axis you want to modify (typically the horizontal axis where categories are displayed).
- Access Axis Options: Right-click on the selected axis. Choose "Format Axis" from the context menu. This will open the Format Axis pane.
- Adjust Horizontal Axis Crosses: In the Format Axis pane, locate the "Axis Options" section. Within this section, find the "Horizontal axis crosses" option.
- Choose a Crossing Point: You have several options for the crossing point:
- Automatic: Excel determines the best position.
- At category number: Specify a specific category number where the axis should cross.
- At maximum category: This will move the axis to the top of the chart (or the maximum value side, depending on the chart type), moving the labels accordingly.
- At axis value: Specify a specific value on the other axis where the horizontal axis should cross.
Example:
The provided video excerpt suggests using "At maximum category" to move the horizontal axis and labels to the top of the chart. This is a common technique for improving readability in certain chart types.
