Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
“2010 Sales” is an example, as shown in Figure
11-23. The chart also has a category axis title,
“US Locations,” to clarify that the cities listed
are just those in the US, not including the other
international locations the company has.
Pick the position for your legend from
this list of five choices.
Give your chart a title to help clarify its subject.
Don’t forget the Layout tab, for anything
that pertains to the placement and
structure of your chart. Along with a Legend
button, which provides the same options
for the position of your legend that are
found in the Format Legend dialog box,
you can customize the placement of your
axes, gridlines, chart wall, and chart
To add a title like the one shown in Figure 11-23
—or to add titles to further explain your category
or value axes—use these tools, found on the
Layout tab, within the Chart Tools section of
Chart Title: This button offers three
options: None, Centered Overlay Title,
and Above Chart. If you choose either of
the last two options, a Chart Title text
box is automatically added to your chart,
as shown in Figure 11-24. To change the
instructional text to your chart’s desired
title, just click on the text and begin
typing. Your text appears on the Formula bar,
and when you press Enter, it replaces
the “Chart Title” text. You can then use the
Home and Format tabs to format the text.
Just like your worksheet probably benefits from
a title—typically housed in a row above the
data—your chart can also benefit from
something to tell viewers what the chart is about.