Microsoft Office Tutorials and References
In Depth Information
It doesn’t matter how spectacular your chart looks if it’s hard to figure out what the
data represents. To clearly explain what’s going on, you need to make sure you have
the right titles and labels.
An ordinary chart can include a main title (like “Increase in Rabbit Population vs.
Decrease in Carrot Supplies”) and titles on each axis (like “Number of Rabbits” and
“Pounds of Carrots”). To show or hide the main title, make a selection from the
Chart Tools | Layout ➝ Labels ➝ Chart Title list. Your options include:
• Above Chart puts a title box at the very top and resizes the chart smaller to
• Centered Overlay Title keeps the chart as is but superimposes the title over the
top. Assuming you can find a spot with no data, you get a more compact display.
• None hides the title altogether.
Once you select one of those options, you see the title box; click inside it, and then
type in new text, as shown in Figure 19-24.
You can type in whatever text you’d like for a chart
title. If you select part of the text, a mini bar appears,
with formatting options for changing the font, size,
color, and alignment. These commands are the same
as in the Home Font section of the ribbon, but it’s ➝
way more convenient to reach them here.
You can just as easily add a title to each axis using the Chart Tools | Layout ➝
Labels ➝ Axis Titles ➝ Primary Horizontal Axis Title and Chart Tools | Layout ➝
Labels ➝ Axis Titles ➝ Primary Vertical Axis Title lists. You’ll find options for
showing your title, hiding it, and (in the case of a vertical axis), showing a title that’s
rotated to run neatly along the side of your chart.
Note: As with almost all chart elements, you can also format titles by adding a border, a shadow effect,
and a fancy background fill. To get these options, right-click the title, and then choose Format Chart Title.