Microsoft Office Tutorials and References
In Depth Information
Figure 4-4: The Patterns tab of the Format Data
Series dialog box
A border is the line around an object. Excel offers three general choices for
formatting a border: Automatic, None, and Custom. By default, borders are set to
Automatic, which means that Excel chooses the border style, color, and weight. To
hide the border around the selected element, choose None. If you modify the Style,
Color, or Weight setting, the border is considered to be a Custom border.
The Border settings are fairly straightforward, so I don’t go into any more detail.
As always, the best advice is to experiment until you get the effect you’re looking for.
Figure 4-5 shows a chart in which the chart title has been formatted. The title
has a thick border and a shadow applied. By default, titles do not have a border.
The area is the interior of a chart element. Not all chart elements have an area.
Again, the Patterns tab of the Format dialog box offers three general choices for
formatting an area: Automatic, None, and Custom.
Notice that the Patterns tab of the Format dialog box does not actually
provide an option labeled Custom. It is assumed that if Automatic and None are
not selected, then the area uses custom formatting.
For standard single-color formatting, just click a color from the palette
displayed. The area labeled Sample displays the selected color.