Applying Conditional Color Fills to Charts

Usually, for a data marker in a chart, it uses a predefined color pattern assigned by the style the chart applies. By using the Conditional Color Fill feature, you can specify color patterns based on different value ranges. With distinguishing colors, it is easy for users to locate the values they need to focus on in a chart. This topic introduces the types of the chart conditional color fills Designer supports and how you can apply them to your charts.

This topic contains the following sections:

Types of Conditional Color Fills
Adding Single-Color Conditional Fill to Chart
- Example: Applying Single-Color Conditional Fill in a Chart
Adding Multiple-Color Conditional Fill to Chart
- Example: Applying Multiple-Color Conditional Fill in a Chart

Types of Conditional Color Fills

Designer supports the following two types of conditional color fills on charts:

Single Color with Condition
With a single color, you can make the data markers that meet the specified condition apply the color pattern bound with the condition.
Multiple Colors with Condition
By using multiple colors, you can divide each data marker into several parts based on different value ranges along the direction of the value axis, and then specify separate color patterns to these different value ranges.

You can apply the Conditional Color Fill feature to the following chart types: Bar, Bench, Pie, Donut, Area 2-D, Area 3-D, Line 2-D, and Heat Map, and use the Multiple Colors with Condition fill type to these chart types only: Clustered Bar/Bench 2-D, Clustered Bar/Bench 3-D, Bar/Bench 3-D, Area 2-D, and Area 3-D.

Adding Single-Color Conditional Fill to Chart

Double-click any data marker in the chart.
In the corresponding format dialog box, switch to the Fill tab.
For a line chart, you can apply conditional color fills to both the chart lines and nodes on the lines in the Fill and Node tabs respectively, using the same method.
Select the Use Single Color with Condition fill type. The following shows a sample dialog box.
You can edit conditional fills in either of the two modes: normal mode or advanced mode (to switch between the two modes, select Advanced or Normal).
To edit conditional fills in normal mode
1. From the Select Field drop-down list, select the field based on which to define the conditions.
2. Select Add to add a condition line.
3. Define the condition.
  - If you select the category/series field of the chart, or a field that does not contain numeric values from the Select Field drop-down list, select a value from the Values drop-down list or type it in the text box. You can specify an empty string as the value for a field of String type, by simply clearing the text box (value length=0).
  - If you select the value field of the chart, or a field containing numeric values from the Select Field drop-down list, specify the start and end values for the condition from the Start Value and End Value drop-down lists or type them in the text boxes. For a 100% Stacked Bar/Bench 2-D chart, 100% Stacked Bar/Bench 3-D chart, 100% Stacked Line 2-D chart, or a pie/donut chart, you can select Percent to display the data in the condition expression in percent; if you select the option, you need to type the percent value in decimal fraction in the Start Value and End Value text boxes.
4. Specify the options such as color and transparency for values in the condition (to change the color, select the color indicator and select a color from the color palette, or type the hexadecimal RGB value of a color in the text box). For a line chart, you can apply color pattern of the node to the corresponding line by selecting Apply Color to Line in the Node tab. Designer then disables the Color and Transparency columns in the Conditional Fill box of the Fill tab.
5. You can customize the legend entry label for values of the condition by selecting Label and then editing the label in the text box. For a line chart, this option is available in the Node tab of the Format Line dialog box only.
6. Repeat the preceding steps to add more conditional fills. To remove a condition fill, select it and select Remove .
7. The values beyond the ranges you have defined in all conditions automatically apply the Other condition settings. You can edit settings of the Other condition and its legend entry label as well.
8. For a line chart, besides options in the Conditional Fill box of the Format Line dialog box, you can specify more line/node formatting for values in a condition.
  - To specify the line formatting of a condition, select the condition and select Edit in the Conditional Fill box in the Fill tab of the Format Line dialog box. In the Edit Line Style dialog box, specify the color and transparency of the chart line and the area formed by the chart axes and the chart line, and the style and thickness of the chart line respectively. Designer displays a sample based on your selection in the Sample box. Select OK if you are satisfied with the style.
  - To specify the node formatting of a condition, select the condition and select Edit in the Conditional Fill box in the Node tab of the Format Line dialog box. In the Edit Node Style dialog box, set Show Node to true if you want to show nodes in the chart line, then specify the style, transparency, width, height, and color of the nodes. In the Border box, set the border properties of the nodes in the selected chart line, including the border color, transparency, line style, and thickness. If you set the node style to plus, multiplication, star1 or star2, Designer displays the Line box instead of the Border box, in which you can specify the line style and thickness for the nodes. Select OK to apply the node style and close the dialog box.
To edit conditional fills in advanced mode
1. Select Add . Designer displays the Edit Conditions dialog box when you are formatting lines of a line chart or rectangles of a heat map, or the Edit Conditions and Label dialog box when you are formatting a bar, bench, pie, or donut chart. The following shows a sample dialog box.
2. From the Select Query for Value Field drop-down list, select the query which contains the fields the values of which you want to use to build the conditions. For a line chart, if you want to use field values to build the conditions, you need to select Imported Conditions at the bottom of the dialog box.
3. Select Add Condition to add a condition line, select the field on which the condition is based from the field drop-down list, specify the operator with which to compose the condition, then select a field in the specified query from the value drop-down list as the value to build the condition or select <Input...> and type the value in the text box. When the condition is based on a String field, you can apply an empty string as the value, by simply leaving the text box blank (value length=0). For a 100% Stacked Bar/Bench 2-D chart, 100% Stacked Bar/Bench 3-D chart, or a pie/donut chart, if you specify to define the condition on a field that contains numeric values, you can control whether to display data in the condition expression as value or in percent by selecting Value or Percent at the right bottom of the dialog box.
4. Repeat the preceding step to define more condition lines and specify the logic relationship between the condition lines: "And", "Or", "And Not", or "Or Not".
  - To group some condition lines, select them and select Group, Designer then adds the selected condition lines in one group and applies them as one line of filter expression (you can also group conditions and groups together).
  - To take out any condition or group from a group, select it and select Ungroup.
  - To adjust the priority of the condition lines, select it and select Up or Down.
  - To delete a condition line, select it and select Delete.
5. Specify the fill pattern for values that meet the condition.
  - For a chart other than the Line type, select the fields in the specified query to control the color and transparency of the condition. The values of the field that you select to control color should contain strings such as "0x000000", and the values of the field used to control transparency should be integers between 0 and 100; otherwise, select <Input...> and type the value in the text box.
  - For a line chart, specify the line formatting/node formatting. When you select Imported Conditions, you can select the fields in the specified query to control some of the options, such as Color and Transparency.
6. In the Label text box (not available when you are formatting lines of a line chart or heat map rectangles), specify the legend entry label for values of the condition. You can also select Customized and then select Edit to customize the label in the Label Editor dialog box.
7. Select OK to close the dialog box and return to the format dialog box. Designer displays the condition in the Conditional Fill box in the format dialog box. You can select Edit to further edit the conditional fill if you want.
8. For a heat map, you can select Label to edit the legend entry label for values of the condition. For a bar, bench, line, pie, or donut chart, you can also further edit the label as described in step f.
9. For a bar, bench, or line chart, you can select Add and repeat the preceding steps to add more conditional fills.
10. The values beyond the ranges you have defined in all conditions automatically apply the Other condition settings. You can edit settings of the Other condition and its legend entry label as well. For a line chart, besides options in the Conditional Fill box, you can select Edit to specify more conditional fill settings for the Other condition in the same way as you do when editing the conditional fills in normal mode.
Select OK to accept the settings and close the dialog box.

Example: Applying Single-Color Conditional Fill in a Chart

Make sure SampleReports.cat is the currently open catalog file. If not, navigate to File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
Navigate to File > New > Web Report to create a web report.
Insert a chart in the web report as follows:

Use WorldWideSalesBV in Data Source 1 of the catalog.
Display in the Clustered Pie chart type.
Show the group object City on the category axis and the aggregation object Total Sales on the value axis.
Apply a Select N condition to the category field City to show its Top 12 values only.
Use the Basic style.

Double-click a pie section in the chart. Designer displays the Format Pie dialog box.
Select the Data Label tab, select Show Static Data Label, select slim leg from the Position drop-down list, then select OK.
Save the report and select the View tab to preview the chart.
Select the Design tab to go back to design mode.
Double-click a pie section to open the Format Pie dialog box again.
Go to the Fill tab and select Use Single Color with Condition.
From the Select Field drop-down list, select [Category]City.
Select Add three times to add three condition lines and specify the condition values and colors respectively as seen in the following image.
Select OK to apply the settings and close the dialog box.
Preview the chart again. Designer now fills the pie sections that represent Almaty, Brussels, and Beijing with the specified colors, and distributes all the other cities to the Other group.

Next, we use percentage values to edit the conditions.

Switch to design mode and open the Format Pie dialog box again.
In the Fill tab, select [Value]Total Sales from the Select Field drop-down list and select Percent.
Specify the color for the Other condition to FBFBC4.
Select Add to add a condition line, set the start value of the condition to 0.04 and end value to 0.06, and specify the condition color to 00CCFF.
Select Label and modify the legend entry label for the value range to 4% <= Total Sales < 6%.
Select OK to accept the changes and close the dialog box.
Preview the chart. Designer fills the Other group and all the pie sections whose values are between 4% and 6% of the total value with the defined colors.
To make the result clearer, you can display data label of the pie sections in percent by setting the Data Label Type property of the chart paper to percent in the Report Inspector.

Adding Multiple-Color Conditional Fill to Chart

You can apply the Multiple Colors with Condition fill type to the following chart types only: Clustered Bar/Bench 2-D, Clustered Bar/Bench 3-D, Bar/Bench 3-D, Area 2-D, and Area 3-D.

Double-click any data marker in the chart.
In the corresponding format dialog box, select the Fill tab.
Select the Use Multiple Colors with Condition fill type. The following shows a sample dialog box.
Select Add to add a condition line, specify the start value and end value for the condition from the drop-down lists or type them in the text boxes, then set the color and color transparency for the value range (to change the color, select the color indicator and select a color from the color palette, or type the hexadecimal RGB value of a color in the text box).
You can customize the legend entry label for values of the condition by selecting Label and then editing the label in the text box.
Repeat the preceding steps to add more conditional fills.
The values beyond the ranges you have defined in all conditions automatically apply the Other condition settings. You can edit the color and transparency of the Other condition and its legend entry label as well.
Select OK to accept the settings and close the dialog box.

Example: Applying Multiple-Color Conditional Fill in a Chart

Make sure SampleReports.cat is the currently open catalog file. If not, navigate to File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
Navigate to File > New > Web Report to create a web report.
Insert a chart in the web report as follows:

Use WorldWideSalesBV in Data Source 1 of the catalog.
Display in the Clustered Bar 2-D chart type.
Show City on the category axis and Total Sales on the value axis.
Apply a Select N condition to the category field City to show its Top 12 values only.
Use the Basic style.

Save the report and select the View tab to preview the chart.
Select the Design tab to go back to design mode.
Double-click a bar in the chart. Designer displays Format Bar dialog box.
Select the Fill tab, then select the Use Multiple Colors with Condition fill type.
Designer selects the value field Total Sales in the Select Field drop-down list by default. Select Add four times to add four condition lines and specify the condition values and colors respectively as seen in the following image.
Select OK to apply the settings and close the dialog box.
Preview the chart again. Designer now divides each bar into several parts based on different value ranges and fills them with different conditional colors.

Previous Topic Next Topic