O'Reilly logo

Microsoft Excel 2010 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

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

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