Chapter 49 Sparklines

Questions answered in this chapter:

  • How can you graphically summarize daily customer counts for each of a bank’s branches in a single cell?

  • How can you modify sparklines?

  • How can you summarize an NFL team’s sequence of wins or losses in a single cell?

  • Do sparklines automatically update when new data is included?

Sparklines are exciting graphics that can summarize a row or column of data in a single cell. The term sparkline was first used by Edward Tufte, a famous expert on the visual presentation of data and its analysis. Tufte described sparklines as “data-intense, design-simple, word-sized graphics.” Microsoft Excel 2019 makes it a snap to create amazing graphics that reside in a single cell.

Answers to this chapter’s ...

Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition 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.