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

Worksheet Charting 101 539
Figure 1-12:
Formatting the Vertical (Value) Axis with the options in the Format Axis task pane.
✦ Units to change the units used in separating the tick marks on the axis. Use the Major option to modify the distance between major horizontal tick marks (assuming they’re displayed) in the chart by clicking its Fixed option button and then entering the number of the new distance in its text box. Use the Minor option to modify the distance between minor horizontal tick marks (assuming they’re displayed) in the chart by click- ing its Fixed option button and then entering the number of the new dis- tance in its text box.
✦ Horizontal Axis Crosses to reposition the point at which the horizontal axis crosses the vertical axis by clicking the Axis Value option button and then entering the value in the chart at which the horizontal axis is to cross or by clicking the Maximum Axis Value option button to have the horizontal axis cross after the highest value, putting the category axis labels at the top of the chart’s frame.
✦ Logarithmic Scale to base the value axis scale upon powers of ten and recalculate the Minimum, Maximum, Major Unit, and Minor Unit accord- ingly by selecting its check box to put a check mark in it. Enter a new number in its text box if you want the logarithmic scale to use a base other than 10.
✦ Values in Reverse Order to place the lowest value on the chart at the top of the scale and the highest value at the bottom (as you might want to do in a chart to emphasize the negative effect of the larger values) by selecting its check box to put a check mark in it.
Book V Chapter 1
Charting Worksheet Data