Database Reference
In-Depth Information
Another strength of using Excel is conditional formatting, which is used to
create heatmaps, as well as the data bars. You can read more about heatmaps
in Chapter 16, but an example of one is shown in Figure 12-17.
Getting the slicers
set up along the top
simply requires set-
ting the number of
columns in the slicer
settings. You would
do this by clicking on
the slicer, and choos-
ing Position and
Layout in the pane on
the right hand side,
and changing the
number of columns in
the text box.
F I g u R e 12 -17
A heatmap in Excel
heATmAPs And Columns
In Figure 12-17, the columns were set up individually with conditional
formatting, as the numbers in the different columns are not comparable.
Grand totals were also removed for this reason.
PoWEr VIEW
Power View is a good tool for interactive comparison visualizations. The auto-
matic linking of column and bar charts on the same page is very useful. Just
as with PerformancePoint, though, the level of control over the visualization
is very limited. Figure 12-18 shows an example of a dashboard with a slicer, a
