Page 558 - Excel 2013 All-in-One For Dummies

540 Worksheet Charting 101
The Axis Options for formatting the Horizontal (Category) Axis include
✦ Axis Type to indicate for formatting purposes that the axis labels are text entries by clicking the Text Axis option button, or indicate that they are dates by clicking the Date Axis option button.
✦ Vertical Axis Crosses to reposition the point at which the vertical axis crosses the horizontal axis by clicking the At Category Number option button. Then enter the number of the category in the chart (with 1 indi- cating the leftmost category) after which the vertical axis is to cross or by clicking the At Maximum option button to have the vertical axis cross after the very last category on the right edge of the chart’s frame.
✦ Axis Position to reposition the horizontal axis so that its first category is located at the vertical axis on the left edge of the chart’s frame and the last category is on the right edge of the chart’s frame by selecting the On Tick Marks option button rather than between the tick marks (the default setting).
✦ Categories in Reverse Order to reverse the order in which the data markers and their categories appear on the horizontal axis by clicking its check box to put a check mark in it.
The Tick Marks options in the Format Axis task pane include the following two options whether the Horizontal (Category) Axis or the Vertical (Value) Axis is selected:
✦ Major Type to change how the major horizontal or vertical tick marks intersect the opposite axis by selecting the Inside, Outside, or Cross option from its drop-down list.
✦ Minor Type to change how the minor horizontal or vertical tick marks intersect the opposite axis by selecting the Inside, Outside, or Cross option from its drop-down list.
In addition to changing y- and x-axis formatting settings with the options found in the Axis Options and Tick Marks sections in the Format Axis task pane, you can modify the position of the axis labels with the Label Position option under Labels and number formatting assigned to the values displayed in the axis with Category option under Number.
To reposition the axis labels, click Labels in the Format Axis task pane
to expand and display its options. When the Vertical (Value) Axis is the selected chart element, you can use the Label Position option to change the position to beneath the horizontal axis by selecting the Low option, to above the chart’s frame by selecting the High option, or to completely remove their display in the chart by selecting the None option on its drop-down list.
When the Horizontal (Category) Axis is selected, you can also specify the Interval between the Labels on this axis, specify their Distance from the Axis