Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
The reward for your efforts is a view that is cleaner and much better suited for reporting in a
dashboard environment. Figure 4-25 illustrates the improvement gained with this technique.
Figure 4-25: Data Bars cleanly placed next to the data values.
Using the same technique, you can separate icon sets from the data, allowing you to position the
icons where they best suit your dashboard.
Representing trends with icon sets
In a dashboard environment, there may not always be enough space available to add a chart that
shows trending. In these cases, icon sets are an ideal replacement, enabling you to visually represent
the overall trending without taking up a lot of space. Figure 4-26 illustrates this with a table that
provides a nice visual element, allowing for an at-a-glance view of which markets are up, down, and flat
over the previous month.
In your situations, you will want to do the same type of thing. The key is to create a formula that gives
you a variance or trending of some sort.
Figure 4-26: Conditional Formatting icon sets enable trending visualizations.
To achieve this type of view, follow these steps:
1. Select the target range of cells to which you need to apply the conditional formatting.
In this case, the target range will be the cells that hold your variance formulas.