Database Reference
In-Depth Information
pivot the table, and then finish touching it up. (You work with pivot tables in
the “Embedding Visualizations in a Pivot Table” section later in this chapter.)
The final result is shown in Figure 15-4.
FI g u R e 15 - 4
A pivot table
Finishing off any table in this manner is essential before even diving into the
rest of the visualization techniques—it is a subtle and yet powerful way of
highlighting the data points you wish your audience to notice.
EMBEDDED CHArTS: SPArKLINES AND BArS
Embedding charts in a table is an excellent way to have a repeating set of
data that can be easily compared—for instance, the growth of product sales
over time or the trades of stocks over time.
In Figure 15-5, a sparkline has been used to show the national reserves of the
BRICSA countries (Brazil, Russia, India, China, and South Africa) for the first 6
months of 2012.
FIguRe 15-5
Sparklines embedded in a pivot table
