CHAPTER 17Dashboarding with sparklines in Excel 2019

In this chapter, you will:

  • Create sparklines

  • Scale sparklines

  • Format sparklines

  • Create a dashboard

A feature that’s been around since Excel 2010 is the ability to create tiny, word-size charts called spark­lines. If you are creating dashboards, you will want to leverage these charts.

The concept of sparklines was first introduced by Professor Edward Tufte, who promoted sparklines as a way to show a maximum amount of information with a minimal amount of ink.

Microsoft supports three types of sparklines:

  • Line—A sparkline shows a single series on a line chart within a single cell. On a sparkline, you can add markers for the highest point, the lowest point, the first point, and the last point. ...

Get Microsoft Excel 2019 VBA and Macros, First Edition now with O’Reilly online learning.

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