Edit Conditions and Label Dialog Box

You can use the Edit Conditions and Label dialog box to edit advanced single color conditional fill and legend entry labels for your bar, bench, line, pie, and donut charts. This topic describes the options in the dialog box, which vary by chart type.

When you open the dialog box from the Format Bar dialog box, Format Pie dialog box, or Format Donut dialog box, Designer displays these options:

Edit Conditions and Label dialog box - For Bar/Pie/Donut Chart

Select Query for Value Field

This drop-down list contains the queries which you can use for editing the conditions. Select the query which contains the fields you want to use as the values to build the conditions.

Add Condition

Select to add a new condition.

Delete

Select to delete the specified condition.

Group

Select to add the specified conditions in a group. You can also add conditions to an existing group by selecting the conditions and the group while holding Ctrl on the keyboard and then selecting the Group button.

Ungroup

Select to ungroup the specified conditions.

Select to move the specified condition or group up to a higher level.

Down

Select to move the specified condition or group down to a lower level.

Logical operator drop-down menu

Specify the logical operator to apply for the specified conditions. It can be "And", "Or", "And Not", or "Or Not".

Field text box

Specify the field on which to define the condition.

Operator drop-down list

Specify the operator to compose the condition. It can be "=", ">", ">=", "<", "<=", or "!=".

Value text box

Specify the field in the selected query as the value to build the condition. You can also select <Input...> and type the value in the text box.

Condition Expression

This box displays the SQL statement of the conditions.

Color

Specify the color to apply to the chart values which meet the condition. Select a field in the specified query the values of which contain strings such as 0x000000 to control the color, or select <Input...> and type the value in the text box.

Transparency

Specify the transparency of the color. Select a field in the specified query the values of which are integers between 0 and 100 to control the transparency, or select <Input...> and type the value in the text box.

Value

Select to display the data in the condition expression as value. Designer applies this option only when the field which the condition is based on is a value field of the chart, or a field containing numeric values.

Percent

Select to display the data in the condition expression in percent. Designer applies this option only to pie chart, 100% Stacked Bar/Bench 2-D chart, and 100% Stacked Bar/Bench 3-D chart, and only when the field which the condition is based on is a value field of the chart, or a field containing numeric values.

Label

Specify the legend entry label for values of the condition. You can edit the label in the text box, or select Customized and then select Edit Edit button to customize the label in the Label Editor dialog box.

Select to apply your settings and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

When you open the dialog box from the Node tab of the Format Line dialog box, Designer displays these options:

Edit Conditions and Label dialog box - For Line Node

Select Query for Value Field

Designer displays the drop-down list when you select Imported Conditions. It contains the queries which you can use for editing the conditions. Select the query that contains the fields you want to use as the values to build the conditions.

Add Condition

Select to add a new condition.

Delete

Select to delete the specified condition.

Group

Ungroup

Select to ungroup the specified conditions.

Select to move the specified condition or group up to a higher level.

Down

Select to move the specified condition or group down to a lower level.

Logical operator drop-down menu

Specify the logical operator to apply for the specified conditions. It can be "And", "Or", "And Not", or "Or Not".

Field text box

Specify the field on which to define the condition.

Operator drop-down list

Specify the operator to compose the condition. It can be "=", ">", ">=", "<", "<=", "!=".

Value text box

Specify the value of how to build the condition. When you select Imported Conditions, you can select a field in the specified query as the value to build the condition.

Condition Expression

This box displays the SQL statement of the conditions.

Shape

You can specify the shape properties of the nodes, the values of which meet the condition in this box.

Style
Specify the style of the nodes.
Transparency
Specify the transparency of the color. When you select Imported Conditions, you can select a field in the specified query the values of which are integers between 0 and 100 to control the transparency, or select <Input...> and type the value in the text box.
Show Node
Specify whether to show the nodes. When you select Imported Conditions, you can select a field in the specified query the values of which are true and false to control it, or select <Input...> and type the value in the text box. The node related properties for the line chart take effect only when you set this option to "true".
Width
Specify the width of the nodes, in pixels.
Height
Specify the height of the nodes, in pixels.
Color
Specify the color of the nodes.
- When you do not select Imported Conditions, you can select the color indicator and select a color from the color palette, or type the hexadecimal RGB value (for example, 0xff0000) of a color in the text box.
- When you select Imported Conditions, you can select a field in the specified query the values of which contain strings such as "0x000000" to control the color, or select <Input...> and type the value in the text box.

Border

Designer displays this box when you select the Style option other than "plus", "multiplication", "star1", or "star2". You can use it to specify the border properties for the nodes, the values of which meet the condition.

Border Color
Specify the color of the border.
- When you do not select Imported Conditions, you can select the color indicator and select a color from the color palette, or type the hexadecimal RGB value (for example, 0xff0000) of a color in the text box.
- When you select Imported Conditions, you can select a field in the specified query the values of which contain strings such as "0x000000" to control the color, or select <Input...> and type the value in the text box.
Transparency
Specify the transparency of the border. When you select Imported Conditions, you can select a field in the specified query the values of which are integers between 0 and 100 to control the transparency, or select <Input...> and type the value in the text box.
Thickness
Specify the width of the border, in pixels.
Line Style
Select the line style of the border.

Line

Designer displays the box when you select the Style option of "plus", "multiplication", "star1", or "star2". You can use it to specify the line properties for the nodes, the values of which meet the condition.

Thickness
Specify the width of the nodes, in pixels.
Line Style
Select the line style of the nodes.

Imported Conditions

Select to use field values to build the conditions and control values of some node properties.