Microsoft Excel 2019 VBA and Macros, First Edition

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