Microsoft Office Tutorials and References
In Depth Information
Changing Chart Gridlines and Axes
Changing Chart Gridlines and Axes
You can change the chart display by showing axis or gridlines with different measure-
ments. An axis is a line bordering the chart plot area used as a reference for measurement.
Chart axes are typically x (vertical or value), y (horizontal or category), and z (only for
3-D charts). If axis titles or scales are too long and unreadable, you might want to change
the angle to make titles fit better in a small space, or change the interval between tick
marks and axis labels to display with a better scale. Tick marks are small lines of meas-
urement similar to divisions on a ruler on an axis. Gridlines are horizontal and vertical
lines you can add to help the reader determine data point values in a chart. There are two
types of gridlines: major and minor. Major gridlines occur at each value on an axis, while
minor gridlines occur between values on an axis. Use gridlines sparingly and only when
they improve the readability of a chart. You can select an Options command on th Add
Chart Elements button or double-click an element to open the Format pane ( New ! ), where
you can customize chart settings.
Change Chart Gridlines
Select the chart element you want to modify.
Click the Design tab under Chart Tools.
Click the Add Chart Elements button, point to Gridlines , and then click to
toggle on or off any of the following options:
Primary Major Horizontal
Primary Major Vertical
Primary Minor Horizontal
Primary Minor Vertical
To select custom chart gridlines options, click the Add Chart Element s, point
to Gridlines , and then click More Gridline Options .
• In the Format pane ( New ! ), click a button (Fill & Line or Effects), expand a
category, and then select the gridline options you want.
• Click the Close button in the pane.
Search JabSto ::




Custom Search