Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Excel 2013 has a handful of preprogrammed scenarios that can be leveraged when you want to
spend less time configuring your conditional formatting and more time analyzing your data. For
example, to create the data bars you’ve just employed, Excel uses a predefined algorithm that
takes the largest and smallest values in the selected range and calculates the condition levels for
each bar.
Other examples of preprogrammed scenarios include
Top Nth Items
Top Nth %
Bottom Nth Items
Bottom Nth %
Above Average
Below Average
To remove the applied conditional formatting, place your cursor in the pivot table and then select
Home Conditional Formatting Clear Rules Clear Rules from This PivotTable.
Customizing conditional formatting
You are by no means limited to preprogrammed scenarios. You can create your own custom
conditions. To see what we mean, create the pivot table shown in Figure 15-13.
Figure 15-13: This pivot shows Sales_Amount, Contracted_Hours, and a calculated field that calculates Dollars
per Hour.
Search JabSto ::




Custom Search