Graphics Reference
In-Depth Information
sorting with some light programming. By convention, the same sorting is
always applied to both the rows and columns. Using Excel and sorted
adjacency matrices are discussed in more detail in Chapter 7,
“Point-and-Click Graph Tools.”
Treemap
A
treemap
isarepresentation ofahierarchy asaseries ofnested rectangles
completely filling the plot. The size of each rectangle is based on a quantity.
You can visibly see the proportion of each item relative to its peers in the
group.
Figure 4-23
(created with MicroStrategy Analytics Desktop) shows a
treemap of U.S. inflation data as indicated by the various components that
make up Consumer Price Index (CPI). The size of each box indicates the
portion ofthecomponent within theCPI, and thecolorindicates thepercent
change over the first decade of the 2000s. Large items contribute significant
weight to the CPI—the cost of housing is the single largest expense. Bright
green items have increased the most—gasoline costs went up significantly
in the 2000s. Bright red items have gone down the most—television prices
have dropped significantly (for example, a 55-inch television would have
been very expensive in 2000 and much more affordable in 2010).
