Microsoft Office Tutorials and References
In Depth Information
Chapter 21: Using sparklines
CHAPTER 21
Using sparklines
Creating sparklines...............................712
Customizing sparklines ...........................714
Removing sparklines .............................717
THE charting features introduced in Chapter 19, “Designing charts,” create graphic
objects that can be moved and sized independently from the worksheet. They reside
in a graphics layer that lies atop the worksheet grid. In contrast to these familiar
chart objects, sparklines , a feature that was introduced in Microsoft Excel 2010, are graphic
representations of data that live within worksheet cells. Described by their inventor, Edward
Tufte, as “intense, simple, word-sized graphics,” sparklines are ideal for situations in which
simplicity and spatial economy matter more than graphic elaboration.
Figure 21-1 provides an example. Each sparkline in cells C3:C11 is a graphic summary of
the monthly data in D3:J11. A glance at the sparklines tells us that Tony Madigan’s numbers
rose steadily through the first five months; that Gisli Olafsson’s began lat and then picked
up for a while; that Geert Camelbeke’s began high and then dropped; and that the others’
varied randomly. Gleaning this much information from a direct inspection of the numbers
would be laborious.
Figure 21-1 Sparklines, such as those in column C of this example, let you implant miniature line
or column charts within worksheet cells.
711
Search JabSto ::




Custom Search