Create an Advanced Conditional Palette for charts

Advanced conditions allow you to use a calculations or expression to evaluate the condition. If multiple advanced conditions are met, only the first conditional style is applied.

Procedure

  1. Select the chart series to which you want to apply the conditional palette.
  2. In the Properties pane, under Conditional, double-click the Conditional styles property.
  3. Click the Add icon new icon and click Advanced Conditional Style.
  4. Click the new advanced condition icon new icon and specify the expression that defines the condition.

    The new advanced condition appears in the Conditional Style - Advanced dialog box.

  5. Under Palette Entry, beside the new advanced condition, click the edit button edit button.
  6. Define the palette entry fill type, colors, and angle, and click OK.
  7. Specify the order in which to evaluate the conditions by clicking a condition and then clicking the move up or move down arrow.

    Conditions are evaluated from top to bottom, and the first condition that is met is applied.