Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
5. Click OK to apply the conditional formatting.
As you can see in Figure 15-17, you now have icons that allow you to quickly determine
where each market falls in relation to other markets as it pertains to revenue.
Figure 15-17: You have applied your first custom conditional formatting!
6. Apply the same conditional formatting to the Dollars per Hour field.
When you are done, your pivot table should look similar to the one shown in Figure 15-18.
Figure 15-18: You have successfully created an interactive visualization.
Take a moment to analyze what you have here. With this view, a manager can analyze the relationship
between total revenue and dollars per hour. For example, the Dallas market manager can see that he is
in the bottom percentile for revenue but in the top percentile for dollars per hour. With this
information, he immediately sees that his dollars per hour rates may be too high for his market. Conversely, the
New York market manager can see that she is in the top percentile for revenue but in the bottom
percentile for dollars per hour. This tells her that her dollars-per-hour rates may be too low for her market.
And all this is driven by a pivot table and some conditional formatting!