Microsoft Office Tutorials and References
In Depth Information
Be aware of grayscale conversion
Be aware of grayscale conversion
Not everyone has a color printer. And even if your chart is printed on a color
printer, someone might photocopy or fax it. One way to determine how your colors
will look when converted to grayscale is to use Excel’s print preview feature (and
make sure that a noncolor printer is selected).
For more information about Excel’s color system and color-to-grayscale
conversion, refer to the excel color system.htm document in the Bonus
Material directory on the companion CD-ROM.
Text and font mistakes
Quite a few chart elements can contain text: titles, axis labels, legends, data labels,
and so on. Perhaps the most common problem is too much text in a chart. A chart
should stand on its own, and lengthy explanatory text should not be necessary (see
Figure 11-21).
Figure 11-21: There’s a chart in here somewhere.
A very common problem with Excel charts is displaying text correctly on the
category axis. The problem is that lengthy text often doesn’t fit, and Excel
automatically rotates the text.
Figure 11-22 shows an example of a chart in which the category axis text has
been rotated. The main problem is that the text takes up an inordinate amount of
space in the chart, at the expense of the Plot Area. Although the rotated text often
looks terrible on-screen, it looks much better when printed.
Search JabSto ::

Custom Search