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 you to locate the values you need to focus on in a chart.

This topic includes the following sections:

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

Types of Conditional Color Fills in Charts

There are two types of conditional color fills for charts in Logi Report Designer:

Single Color with Condition
With a single color, you can make the data marker that meets 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 different parts based on different value ranges along the direction of the value axis, and then specify different color patterns to different value ranges.

The Conditional Color Fill feature is supported on the following chart types: Bar, Bench, Pie, Donut, Area 2-D, Area 3-D, Line 2-D and Heat Map, and for the Multiple Colors with Condition fill type, Clustered Bar/Bench 2-D, Clustered Bar/Bench 3-D, Bar/Bench 3-D, Area 2-D and Area 3-D chart types only.

Adding Single-Color Conditional Fill to a Chart

Double-click on any data marker in the chart.
In the corresponding format dialog, switch to the Fill tab. For a line chart, you can set conditional color fills on both the chart line and the nodes on the lines in the Fill and Node tab respectively using the same method.
Select the fill type as Use Single Color with Condition. See a sample dialog below.
You can edit the conditional fills in either of the two modes: normal mode or advanced mode (to switch between the two modes, select the Advanced or Normal button).
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 to add a condition line.
3. Define the condition.
  - When the category/series field or a field whose return value is not a number is selected from the Select Field drop-down list, select a value from the Values drop-down list or type it directly 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).
  - When the value field or a field that returns a number is selected 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 directly in the text boxes.
    For 100% Stacked Bar/Bench 2-D chart, 100% Stacked Bar/Bench 3-D chart, 100% Stacked Line 2-D chart or Pie/Donut chart, you can display the data in the condition expression in percent. To achieve it, select Percent, and then type the percent value in decimal fraction in the Start Value and End Value text boxes.
4. Set the properties 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 value of a color in the text box).
  For a line chart, you can make the color pattern specified on the node apply to the corresponding line. To do this, in the Node tab, select Apply Color to Line. The Color and Transparency properties in the Fill tab will then be disabled.
5. By default, the expression of the condition will be shown as its legend entry label. If you want to change it, select Label and change the label in the text box that follows. For a line chart, this option is available in the Node tab of the Format Line dialog only.
6. Select and repeat the above steps to add more conditional fills.
7. The values beyond the ranges you have defined in all your conditions will automatically apply the Other condition settings. You can edit properties of the Other condition and edit its legend entry label as well.
8. For a line chart, besides properties in the Conditional Fill box of the Format Line dialog, you can edit more line/node properties for values in a condition.
  To edit the line properties of a condition, select the condition and select in the Conditional Fill box in the Fill tab of the Format Line dialog. In the Edit Line Style dialog, 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. A sample based on your selection will be displayed in the Sample box. Select OK if you are satisfied with the format.
  To edit the node properties of a condition, select the condition and select in the Conditional Fill box in the Node tab of the Format Line dialog. In the Edit Node Style dialog, set Show Node to true if you want to show the 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 border color, transparency, line style and thickness. If you set the node style to plus, multiplication, star1 or star2, the Line box is available instead of the Border box, in which you can specify the line style and thickness for the nodes with selected styles. Select OK to apply the node properties and close the dialog.
To edit conditional fills in advanced mode:
1. Select to add a condition in the Edit Conditions dialog. The following is a sample dialog.
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.
3. Select the Add Condition button to add a condition, select a 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. You can specify an empty string as the value for a field of String type, by simply leaving the text box blank (value length=0).
  You can repeat this to add more conditions. To make some conditions grouped, select them and select the Group button, then the selected conditions will be added in one group and work as one line of filter expression. Conditions and groups together can be further grouped. To take any condition or group in a group out, select it and select Ungroup. To adjust the priority of the conditions, select it and select the Up or Down button. To delete a condition, select it and select the Delete button.
  For 100% Stacked Bar/Bench 2-D chart, 100% Stacked Bar/Bench 3-D chart or Pie/Donut chart, if you select a value field from the field drop-down list, you can control whether to display the data in the condition expression as value or in percent by selecting Value or Percent at the right bottom of the dialog.
4. Specify the fill properties for values in 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, however the values of the field 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 values for the line properties/node properties. When Imported Conditions is selected, you can select the fields in the specified query to control some of the properties, such as Color and Transparency.
5. Select OK to close the dialog and return to the chart format dialog.
  The condition specified in the Edit Conditions dialog is now listed in the Conditional Fill box in the chart format dialog. You can select to further edit the condition and the corresponding conditional fill properties.
6. By default, the expression of the condition will be shown as the legend entry label. If you want to change it, select Label and change the label in the text box that follows. For a line chart, this option is available in the Node tab of the Format Line dialog only.
7. For a chart of Bar, Bench or Line type, you can select and repeat the above steps to add more conditional fills.
8. The values beyond the ranges you have defined in all your conditions will automatically apply the Other condition settings. You can edit properties of the Other condition and edit its legend entry label as well. For a line chart, besides properties in the Conditional Fill box, you can select to edit more conditional fill properties 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.

Example of Applying Single-Color Conditional Fill in a Chart

Make sure SampleReports.cat is the currently open catalog file. If not select File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
Select 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 as the data source.
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.

Save the report and select the View tab to preview the chart. The chart appears as follows:
Go back to the design mode and double-click a pie in the chart.
In the Format Pie dialog, go to the Fill tab and select Use Single Color with Condition.
From the Select Field drop-down list, select [Category]City, select three times to add three condition lines and specify the condition values and colors as follows:
Select OK to apply the settings and close the dialog.
Preview the chart again. Now you can see pie sections that represent the city Almaty, Brussels and Beijing are filled with the defined colors, and other cities are all distributed to the Other group.
Next, we will use percentage values to edit the condition expressions.
Go back to the design mode and open the Format Pie dialog again.
In the Fill tab, select [Value]Total Sales from the Select Field drop-down list and select the Percent radio button. Specify the color for the Other condition to FBFBC4. Select to add a condition line, set the condition Start Value to 0.04, End Value to 0.06 and color to 00CCFF, then select the Label checkbox and modify the condition label to 4% <= Total Sales < 6%.
select OK to accept the settings and close the dialog.
Preview the chart and the result looks like below:
From the result above, you can see the Other group and all the pie sections whose values are between 4% and 6% of the total value are filled with the defined colors. To make the result more clear, you can display the data label of the pie sections in percent by setting the property Data Label Type on the chart paper to percent in the Report Inspector. Then the report result is shown as follows:

Adding Multiple-Color Conditional Fill to a Chart

The fill type Multiple Colors with Condition is supported only on Clustered Bar/Bench 2-D, Clustered Bar/Bench 3-D, Bar/Bench 3-D, Area 2-D and Area 3-D chart types.

Double-click on any data marker in the chart.
In the corresponding format dialog, switch to the Fill tab.
Select the fill type as Use Multiple Colors with Condition. The following is a sample dialog.
Select 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 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 value of a color in the text box).
By default, the expression of the condition will be shown as its legend entry label. If you want to change it, select Label, and then change the label in the text box that follows.
Repeat the above steps to add more conditional fills.
The values beyond the ranges you have defined in all your conditions will automatically apply the Other condition settings. You can edit the color and transparency of the Other condition and edit its legend entry label as well.
Select OK to accept the settings and close the dialog.

Example of applying multiple-color conditional fill in a chart

Make sure SampleReports.cat is the currently open catalog file. If not select File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
Select 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 as the data source.
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.

Save the report and select the View tab to preview the chart. The chart appears as follows:
Back to the design mode and double-click a bar in the chart.
In the Format Bar dialog, select the Fill tab, then select Use Multiple Colors with Condition as the fill type.
The value field Total Sales is selected by default in the Select Field drop-down list. Select four times to add four condition lines and specify the condition values and colors as follows:
By default, the condition expression is used as the legend entry label for each condition. Take the first condition line for example, its condition expression is 10000 <= Total Sales < 20000. Select each condition line and select the Label checkbox one by one. Select OK.
Preview the chart again and it displays as follows now. Each bar is divided into several parts based on different value ranges with different conditional colors.

Previous Topic Next Topic