O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required