33. Using Sparklines

Edward Tufte wrote about small, intense, simple datawords in his 2006 book, Beautiful Evidence. Tufte called them sparklines and produced several examples where you could fit dozens of points of data in the space of a word. Six months later, the Excel team began planning for Excel 2010 and Tufte’s concepts made it into Excel 2010.

Fitting a Chart into the Size of a Cell with Sparklines

Excel’s implementation of sparklines offers line charts, column charts, and a win/ loss chart. See Figure 33.1 for an example of each.

Win/Loss—The 1951 Pennant Race in rows 7 & 8 show two examples of a Win/Loss chart. Each event (in this case, a baseball game) is represented by either an upward facing marker to indicate a win or a downward ...

Get Microsoft Excel 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.