Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 11 Times Series 437

3 Select the range E3:E129 (not E2:E129).

4 Type =D3-D2 in cell E3; then press Enter.

5 Press the Fill button on the Editing group of the Home tab and

then click Down. Excel fills the difference formula down the re-

maining cells in the column, displaying the change in mean annual

temperature from one year to the next.

Now that you have calculated the differences in the mean annual tem-

perature from one year to the next, you can plot those differences.

To plot the change in the temperature versus time:

1 Select the range A1:A129, press and hold the CTRL key, and then

select the range E1:E129.

2 Click the Scatter button from the Charts group on the Insert tab and

click the fi rst chart subtype (Scatter with only markers).

3 Move the chart to a new chart sheet named Yearly Change.

4 Remove the legend and gridlines from the plot.

5 Enter the chart title Yearly Temperature Change. Set the title of the

x axis to Year and the title of the y axis to Change in Temperature (F).

Figure 11-5 shows the formatted scatter chart.

Figure 11-5
Yearly
differences
in mean global

temperature