Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
In this section, you find out how to leverage the magic combination of pivot tables and conditional
formatting to create interactive visualizations that serve as an alternative to pivot charts.
To start the first example, create the pivot table shown in Figure 15-9.
Figure 15-9: Create this pivot table.
Suppose you want to create a report that allows your managers to see the performance of each sales
period graphically. You could build a pivot chart, but you decide to use conditional formatting. In this
example, go the easy route and quickly apply some data bars:
1. Select all the Sum of Sales_Amount2 values in the values area.
2. Click the Home tab and select Conditional Formatting ➜ Data Bars as shown in Figure 15-10.
Figure 15-10: Apply data bars to the values in your pivot table.