|
Once data is added to the pivot, it can be formatted in a variety of ways to help visualize otherwise static data points. For instance, you can highlight cells that meet certain defined criteria.
Formatting can be added, edited and cleared/deleted by clicking Edit Rules from the toolbar or by hovering over the data item and clicking the data item menu drop-down.
Format Rules include:
| • | Value - Add a formatting rule based on an evaluation of static value (e.g. >, <, <=, >=, etc.) |
| • | Top/Bottom - Add formatting based on the evaluation of the topmost or bottommost value |
| • | Average - Add formatting rule based on an evaluation of average (e.g. >, <, <=, >=, etc.) |
| • | Expression - Build an expression to apply formatting (advanced) |
| • | Icon Ranges - Apply icons to items based on an evaluation of a range |
| • | Color Ranges - Apply colors to items based on an evaluation of a range |
| • | Gradient - Apply a color gradient to items based on an evaluation of a range |
| • | Bar - Displays a visual representation of a value using a bar. Bars can be colored based on positive or negative values. |
| • | Bar Color Ranges - Displays a visual representation of a value using a bar. Bars are colored with the color set based on an evaluation of range |
| • | Bar Gradient Ranges - Displays a visual representation of a value using a bar. Bars are colored with the gradient color set based on an evaluation of range |
|