Microsoft Office Tutorials and References
In Depth Information
Formatting axis patterns and tick marks
When this chart was created, range A1:E10 was selected. Excel determined
automatically that the first three columns would be used for the category axis labels.
Alternatively, you can use the Series tab of the Source Data dialog box to change
the range used for the category axis labels.
This type of data layout is common when you work with pivot tables, and
pivot charts often use multiline category axes. Refer to Chapter 9 for more
information about pivot tables and pivot charts.
Formatting axis patterns and tick marks
An axis is a line, and Excel offers the standard line formatting option (style, color
and weight). You adjust these formatting options in the Patterns tab of the Format
Axis dialog box.
An axis also has tick marks — the short lines that depict the scale units and are
perpendicular to the axis. You can select the type of tick mark for the major units
and the minor units. The options are as follows:
None: No tick marks
Inside: Tick marks on the inside of the axis only
Outside: Tick marks on the outside of the axis only
Cross: Tick marks on both sides of the axis
You can also control the position of the tick mark labels. The options are as
follows:
None: No labels
Low: For a horizontal axis, labels appear at the bottom of the plot area;
for a vertical axis, labels appear to the left of the plot area
High: For a horizontal axis, labels appear at the top of the plot area; for a
vertical axis, labels appear to the right of the plot area
Next to axis: Labels appear next to the axis (the default setting)
Major tick marks are the axis tick marks that normally have labels next to
them. Minor tick marks are between the major tick marks.
Search JabSto ::




Custom Search