Create an Advanced Conditional Palette for Current Default 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

Select the chart series to which you want to apply the conditional palette.
In the Properties pane, under Color & Background, double-click the Conditional Palette property.
Click the add button and click Advanced Condition.
Click the new advanced condition button and specify the expression that defines the condition.
The new advanced condition appears in the Conditional Palette - Advanced dialog box.
Under Palette Entry, beside the new advanced condition, click the edit button .
Define the palette entry fill type, colors, and angle, and click OK.
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.