Format Rule: Bar Gradient Ranges

This dialog allows you to change the following options specific to “Bar Gradient Ranges”:

• Number of ranges – “Number of ranges” allows you to specify the number of ranges used to classify Click the Generate Ranges button to generate a new gradient scale according to the specified number of ranges;
• Use % ranges – the “Use % ranges” check box specifies whether the percent or absolute scale is used to generate ranges;
• Range field with specified values:

• Intersection mode – the level at which the highlight will be The levels can be as follows:
  • Auto – identifies the default For the Pivot dashboard item, Auto identifies the “First Level”;
  • First level – first level values are used to apply conditional formatting;
  • Last level – the last level values are used to apply conditional formatting;
  • All levels – all pivot data cells are used to apply conditional formatting;
  • Specific level – values from the specific level are used to apply conditional
• Row/Column dimension – if you specified the Intersection mode as “Specific Level”, use the “Row dimension” and “Column dimension” combo boxes to set the specific level;
• Apply to – to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;
• Apply to row/column – apply to the entire row / to the entire column;
• Allow negative axis – the “Allow negative axis” option allows you to specify whether negative data bars are displayed in the direction opposite to the positive data bars;
• Draw axis – the “Draw axis” option specifies whether to draw the vertical axis between positive and negative data bars;
• Show bar only – the “Show bar” only option specifies whether to show bars without corresponding values.