“For Excel 2010, we’ve implemented sparklines, 'intense, simple, word-sized graphics,’ as their inventor Edward Tufte describes them in his book, Beautiful Evidence. Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing...”
We’ll explore sparklines by creating a variant of our dashboard that shows trend over time for tickets by state using the second PivotTable. This example builds on our previous work in Part IV.
Right-click on and make a copy of your existing sheet and name it Sparklines (Figure 23-1).
Right-click on the worksheet that contains your dashboard.
Select Move or Copy to show the Move or Copy menu (Figure 23-2).
Check Create a copy and click OK.
On the new copy of your dashboard, remove full name from the second PivotTable.
Add State from the People dimension (Figure 23-3).
Tweak the column width or slicer position as required.
To add a sparkline, select the cell, you’d like to insert your sparkline.
Go to ...