Create a Conditional Color Palette for a Legacy Chart

You can create a color palette that appears differently depending on a yes or no answer, an expression or calculation, or the report language.

Procedure

Click the chart object.
In the Properties pane, under Color & Background, double-click the Conditional Palette property.
If you want to create a variable that has only two possible values, Yes and No, do the following:
1. Under Variable, click New boolean variable.
2. In the New Variable dialog box, type a name for the variable.
3. In the Expression Definition box, define the condition and click OK.
  For example, the following expression returns the value Yes if revenue is less than one million and the value No if revenue is greater than or equal to one million:
  
  [Revenue]<1000000
  
  For information about creating expressions, see Using Relational Calculations or Using Dimensional Calculations and Using the expression editor.
4. In the Value box, select whether the expression evaluates to Yes or No.
5. Under Effects, specify the color palette to use for the condition.
If you want to create a variable whose values are string-based, do the following:
1. Under Variable, select New string variable.
2. In the Expression Definition box, define the condition and click OK.
  For example, the following expression returns the value high if revenue is greater than one million and the value low if revenue is less than or equal to one million:
  
  if ([Revenue]>1000000) then ('high') else ('low')
  
  For information about creating expressions, see Using Relational Calculations or Using Dimensional Calculations and Using the expression editor.
3. Click the add button in the Values pane.
4. For each value that the variable can assume, type the name of the value that corresponds with the possible outcomes defined in the expression.
  For example, in the previous expression, you must create two values for the variable, high and low.
  
  Tip: You can create a group by clicking two or more values and then clicking the group values button . For example, you can create a group that includes the available French languages.
If you want to create a variable whose values are different languages, do the following:
1. Under Variable, select Report Language Variable.
2. In the Languages dialog box, select the languages to support.
Click OK to close the expression editor and leave the Conditional Palette dialog box open.
Under Effect, click Pattern.
Under Pattern, select a pattern and click OK.
In the Box section of the Properties pane, set the Borders property to Show.