Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 3 Working with Charts 95

To change the chart title:

1 Click the Graduated title located directly above the scatter plot.

Selection handles appear around the chart title indicating that it is

selected.

2 Type Big Ten Graduation Percentages and press Enter. As shown in

Figure 3-12, the title changes to refl ect the new text.

chart title with

selection handles

Figure 3-12
Changing the
chart title

Next, add titles to both the y axis and x axis. Since these titles are not

currently displayed on the chart you have to add them with the Axis Titles

button.

To insert the axis titles:

1 Click the Axis Titles button from the Labels group on the Layout tab

of the Chart Tools ribbon, click Primary Horizontal Axis Title, and

then click Title Below Axis.

Excel inserts the text Axis Title below the horizontal, or x, axis. The

Axis Title text is surrounded with selection boxes indicating that it

is the currently selected object in the chart.

2 Type Calculated SAT Values and press Enter.

3 Click the Axis Titles button again, click Primary Vertical Axis Title,

and then click Rotated Title.

4 Type Graduation Percentage and press Enter. Figure 3-13 shows the

newly added axis titles.