Microsoft Office Tutorials and References
In Depth Information
Figure 4-5: The chart title has a border
and a shadow.
For more interesting formatting options, don’t overlook the Fill Effects button.
This button displays the Fill Effects dialog box, shown in Figure 4-6. This dialog
box contains four tabs:
Gradient: Enables you to specify colors that are blended together in
various ways. There are literally hundreds of possibilities here.
Texture: Enables you to select from 24 built-in textures. Or, use the Other
Texture button to use a graphic file as a texture.
Pattern: Enables you to choose from 48 two-color patterns. You can
choose the colors. These patterns are sometimes useful for charts that will
be printed using a black-and-white printer, and grayscale doesn’t work
well. If you plan to print your charts, make sure that you do some test
prints to ensure that the patterns print correctly on your printer.
Picture: Enables you to specify a graphics file. You can control how the
picture is displayed: stretched, stacked, or stacked and scaled. This feature
can be put to good use in applying special effects to data series. See
“Formatting Series,” later in this chapter.
In the Gradient tab of the Fill Effects dialog box, the Transparency section is
always disabled. Apparently, Excel is recycling this dialog box, which also is
used to format shapes (the Transparency settings are enabled when a shape
is selected). It is possible, however, to paste transparent shapes into a chart
series. See Chapter 6 for an example.