Microsoft® Excel® 2010 Inside Out

Working with Axes

Excel gives you a great deal of control over the format, position, and scale of your charts’ axes. You can specify the line style, color, and weight of the axes, as well as the presence or absence of tick marks and tick labels. You can also override the default scaling and establish the positions at which vertical and horizontal axes intersect.

Specifying the Line Style, Color, and Weight

The default axis is a thin, solid, black line. But you can replace that with broken or compound lines in various colors and weights. For details, see Formatting Lines and Borders on page 699. Note that Excel draws your tick marks, discussed next, in the same style as your axis. Therefore, if you choose a heavy red line for the axis, you’ll have ...