Create a Simple Conditional Palette for a Chart
You can create a simple conditional palette
based on a string data item or a numeric data item. For example, if
you want to create a condition to display only Revenues over one million
dollars, you can create a numeric condition; whereas, if you want
to create a condition to display only product codes with the letter
A in them, you can create a string condition.
Procedure
- Select the chart series to which you want to apply the conditional palette.
- In the Properties pane, under Conditional, double-click the Conditional styles property.
- Click the New icon and click New Conditional Style.
- If you want to create a conditional palette based on a
string, do the following:
- Select the string data item to determine the condition.
- In the Type of conditional style list, click String, and click OK.
- Click the new button and select how to define the condition:
- To select more than one individual value, click Select Multiple Values and click the values.
- To type specific values, click Enter Values and type the values.
- To specify your own criteria, such as values that begin with the letter A, click Enter String Criteria and specify the condition.
- Under Palette Entry, beside the new condition, click the edit button .
- Define the palette entry fill type, colors, and angle, and click OK.
- If you want to create a conditional palette based on a
numeric range, date/time range, interval range, date range, or time
range, do the following:
- Select a numeric data item to determine the condition.
- In the Type of conditional style list, click the type of condition you want to create, and click OK.
-
Click the new button and type a value to define a threshold.
The value appears in the Range column, and two ranges are created.
- For each range, under Style, click the edit button to define the palette entry fill type, colors, and angle, and then click OK.
-
Repeat the previous substeps to add other conditions.
Tip: Under Style, pause the pointer over each range to see the condition produced for that range.
- If you want to use the default palette for the lowest range instead of specifying a conditional palette select the Use default palette for lowest range check box.
- To move a value above or below a threshold, click the arrow button next to the
value.
For example, you insert a threshold value of five million. By default, the ranges are less than or equal to five million and greater than five million. Moving the five million value above the threshold changes the ranges to less than five million and greater than or equal to five million.
- To customize the label for a conditional palette, do the
following:
- Click Label beside the palette entry.
- In the Conditional Palette Entry Label dialog box, click Specified text and click the ellipsis button.
- Type the default label text in the Label text box.
- To add customized labels for other languages, click the Add icon , select the other languages, and click the language to define the customized label for that language.
- 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.