Excel 2016 VBA and Macros

17. Dashboarding with Sparklines in Excel 2016

In This Chapter

Creating Sparklines

Scaling Sparklines

Formatting Sparklines

Creating a Dashboard

Next Steps

A feature that’s been around since Excel 2010 is the ability to create tiny, word-size charts called sparklines. 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, ...