Datasheet

19
Chapter 1: Evaluating Data in the Real World
Figure 1-3:
Clicking
Insert |
Other Charts
opens this
gallery.
The downside to all this, of course, is the Ribbon’s newness. If you’ve spent
years with previous versions, you’ve developed an overall sense of where fre-
quently used capabilities reside. Now you have to reorient: The switch from
the menu bar to the Ribbon relocates almost everything.
It’s worth your while to reorient. After you get accustomed to the Ribbon,
you’ll see that everything takes just a few steps now.
Wait a second. Figure 1-3 shows a gallery of charts to insert into a worksheet.
What happened to the Chart Wizard? It’s gone from Excel 2007. In keeping
with everything-takes-just-a-few-steps-now, to create a chart you
1. Select the data to include in the chart.
2. Insert the chart into the worksheet.
3. Use the Design tab and the Layout tab to make modifications.
I’ve oversimplified, but not by much, as Chapter 3 shows. Creating a chart is
more intuitive than it used to be. You’re no longer confined to the order of
steps specified in the Chart Wizard.
Wait another second. Design tab? Layout tab? They’re not in Figure 1-2. After
you insert a chart and select it, they appear. Tabs that appear when needed
are called contextual tabs.
Also in keeping with everything-takes-just-a-few-steps-now, to use a statistical
function you
1. Select a cell for the result of the function.
05 454060-ch01.indd 1905 454060-ch01.indd 19 4/21/09 7:17:58 PM4/21/09 7:17:58 PM