Database Reference
In-Depth Information
FI g u R e 15 -22
Extending a sparkline
Once you have done this, collapse the fields again to get a view similar to that
shown in Figure 15-23.
FI g u R e 15 -23
Sparklines in a collapsed pivot table
Immediately apparent is the influence of the missing data in August 2012: Not
all countries have submitted and it distorts the sparklines. Fix this by remov-
ing August completely in the Excel filters. Do so by clicking on the arrow next
to the words “Column labels” and then ticking the multiselect tickbox. Find
