25. 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. 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. Figure 25.1 shows an example of each:

Image Win/Loss—The 1951 Pennant Race (in rows 7 and 8) shows two examples of a Win/Loss chart. Each event (in this case, a baseball game) is represented by either an upward-facing ...

Get Excel 2016 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.