Microsoft Office Tutorials and References
In Depth Information
Be aware of grayscale conversion
Figure 11-22: A common problem is text in category
By default, axis text orientation is set to Automatic, so Excel adjusts the
orientation based on its algorithms. For more control over the axis text, access the Format
Axis dialog box and click the Alignment tab. You can then force the text alignment
to be a specific angle (0 degrees results in normal horizontally oriented text).
After making this change, you may find that Excel skips some of the axis labels.
You can force all axis labels to be displayed by using the Scale tab of the Format
Axis dialog box. Specify a value of 1 for the Number of Categories Between Tick
Mark Labels. Then, you can adjust the font size, Plot Area width, and chart width to
ensure that all category axis labels are displayed properly (see Figure 11-23).
Depending on your Excel version, you may find that Excel sometimes
overrides the Number of Categories Between Tick Mark Labels and continues to
use its own best guess regarding how many labels to display.
Font mistakes generally fall into one or more of the following categories:
Too many different fonts faces. One font per chart almost always works.
Poor choice of fonts. When in doubt, use the Arial font.
Poor choice of font sizes. All text should be large enough to be legible.
Use bold or italic to draw attention to a particular element.
All uppercase or all lowercase text. Text in a chart should generally be
The chart in Figure 11-24 demonstrates all these problems.