Microsoft Office Tutorials and References
In Depth Information
Tip 91: Using Multi-Level Category Labels
You can apply formatting to the category axis labels, but the formatting is applied to all of the text. In
other words, you can’t apply different formatting for each level.
Figure 91-3 shows a variation of the previous example. After creating the chart with a multi-level
category axis, I selected the category axis and pressed Ctrl+1 to display the Format Axis task pane.
In the Axis Options ➜ Labels section, I specified the Label Position to be High. I also deselected the
Multi-level Category Labels option, which has the effect of making the lines closer together.
Figure 91-3: A chart that displays category labels at the top.