Microsoft Office Tutorials and References
In Depth Information
The Design Tab—A Closer Look
Figure 5–27. The data pared into pairs: The Scatter chart
Here the Scatter chart takes the tourist data for each city, pairing each with its 2006 and 2007 tourist
totals. However, the Horizontal axis doesn’t use the city names—it simply numbers each element in the
sequence in which it appears in the source data. Thus, London is 1, Hong Kong 2, etc.
Bear in mind that Excel offers a collection of additional chart types, all of which are available in the
Chart button group (you’ll have to click Other Types to see them), at least some of which you may well
find worth exploring. We’ve devoted our discussion to what are by far the most utilized types.
The Design Tab—A Closer Look
Excel’s charting tools are stored in three different button groups—Design, Layout, and Format. True—if
you woke Bill Gates in the middle of the night, he might not be able to tell you what really distinguishes
the three. Still, those are the three tabs Chart Tools gives us, and it’s time to review some of their
respective options a bit more closely.
Change Chart Type
We’ve already explored the first Design Tab option—Change Chart Type, in the Type Group. To review—
whenever you want to change your current chart, Change Chart Type will unroll Excel’s charting
alternatives. Just click the one you want.
 
Search JabSto ::




Custom Search