Microsoft Office Tutorials and References
In Depth Information
Chapter 20: Formatting charts
CHAPTER 20
Formatting charts
Formatting charts with the Chart Styles gallery ......697
Selecting chart elements..........................698
Repositioning chart elements with the mouse .......699
Formatting lines and borders......................699
Formatting areas.................................702
Formatting text..................................705
Adding arrows, shapes, and text ...................709
IN CHAPTER 19, “Designing charts,” you saw the basic procedures for setting up a chart in
Excel, as well as those for adding titles, axes, gridlines, data labels, and so on. As you’ll
recall, when you create and select a chart object, Excel adds a Chart Tools heading to
the ribbon, with two tabs—labeled Design and Format—subordinate to that new
heading. Virtually all of the procedures described in Chapter 19 are accessible via the Design
tab—although, as always in Excel, there are alternative ways to get the job done that don’t
involve a trip to the ribbon.
In this chapter, we look at issues of style and appearance, aspects of the charting interface
that are accessible via the Format tab, and associated formatting task panes.
Formatting charts with the Chart Styles gallery
Before you get too involved with the kinds of formatting procedures described later in this
chapter, however, be sure to familiarize yourself with the Chart Styles gallery, located in
the middle of the Design tab when a chart is selected. The gallery typically offers a dozen
or more combinations of structural details and formatting choices tailored to the selected
graph; click the arrow in the lower right corner of the gallery to see the entire set of
offerings. You can preview the effect of each style on your chart by passing your mouse through
the gallery. Here’s what the gallery might look like for a simple line chart:
Some of the styles have gridlines, while others do not; some have compound lines, some
have data labels, and some have background colors. (If you want a background color but
697
Search JabSto ::




Custom Search