Data Analysis with Microsoft Excel: Updated for Office 2007

94 Excel

3 Click the OK button.

As shown in Figure 3-11, the chart is moved to a chart sheet named

Graduation Chart.

Move Chart button

Graduation Chart sheet name

Figure 3-11
Newly inserted
chart sheet

Working with Chart and Axis Titles

To make your charts easier to interpret, you should add titles to both axes

and over the entire chart area. By default, Excel will display the name used

for the y axis data values as the chart title. In this case the chart title is

Graduated since the y axis values come from the Graduated column, which

is column G on the Grad Percents worksheet.

To insert different titles, use the Chart Title and Axis Title buttons from

the Chart Tools ribbon or you can select the titles from the chart and type

over the current titles. Try this by changing the chart title to Big Ten Gradu-

ation Percentages.