We can set Conditional Formatting in the Additional Properties panel to create rules that highlight data points in a chart. In this example we want to create Conditional Formatting rules that mark certain Column dimensions with a different color based on their values.

For additional learning please refer to the Video Guide going through the steps to add and modify Conditional Formatting here:

 

ADDING AND CONFIGURING THE CHARTS


Create a new Analysis Application and add a Grid Layout to the Layout view. Set the Margins and the number of Rows and Columns as shown

capture

 

Add two ChartsPLUS 3.0 charts to Cell [0, 0] and Cell [1, 0] of the Grid Layout. Set both their margins as shown

capture

 

Add the following data to our Analysis Application

capture

 

Your application should now look something like

capture

 

Select the topmost chart, ChartsPLUS2_1. We will demonstrate Bullet Color Conditional Formatting for this chart. To do this we first go to Additional Properties and select the Chart Selection icon and set the Chart type to Clustered Bar.

untitled

 

Since we will only be using one graph for this Chart go to Config>>Graphing>>Graphs. Select the Plan graph and Hide it using the Hidden property under the General section. Under Legend turn off the Visible Legend property as well.

untitled

 

Now, to add the Conditional Formatting go to Config>>Conditional Formatting and select Add New ConditionalFormatting. Under Comparator, set the Field Type to By Position and set the Position to 0. Under Percent Target set the Field Type to By Name and set the Field Name to Plan. Now, we will be applying Conditional Formatting rules based on which Plan values match which rules set.

capture

 

Let us now define what the percent-based Conditional Formatting rules will be by adding three Percent rules and configuring them as shown

capture

 

Go back to Config>>Graphing>>Graphs>>Sales and set the Conditional Formatting>>Bullet Color Conditional Formatting to ConditionalFormatting(This is the ID of the conditional formatting rule we just created). Also under Bullets set the Bullet property to Square.

capture

 

Onto the bottom chart, ChartsPLUS2_2. We will demonstrate Fill Color Conditional Formatting for this chart. Since we will only be using one graph for this Chart go to Config>>Graphing>>Graphs. Select the Plan graph and Hide it using the Hidden property under the General section. Under Legend turn off the Visible Legend property as well.

untitled

 

Now, to add the Conditional Formatting go to Config>>Conditional Formatting and select Add New ConditionalFormatting. Under Comparator, set the Field Type to By Position and set the Position to 0. Under Percent Target set the Field Type to By Name and set the Field Name to Plan. Now, we will be applying Conditional Formatting rules based on which Plan values match which rules set.

capture

 

Let us now define what the percent-based Conditional Formatting rules will be by adding three Percent rules and configuring them as shown

capture

 

Go back to Config>>Graphing>>Graphs>>Sales and set the Conditional Formatting>>Conditional Formatting to ConditionalFormatting. Also, under Appearance>>Fill Colors set the Line Opacity to 0%.

capture

 

TESTING THE APPLICATION


Let us Execute the Application Locally by clicking the green Execute button, our application shows us how both the charts have been modified by the Conditional Formatting rules applied to the application.

The top chart displays Bullets at the end of each Sales bar displaying the color assigned to the Plan graph according to the Conditional Formatting rules. The bottom chart modifies the Fill Color of all the columns in a similar way.

capture

 

For additional information on ChartsPLUS and to download a free trial click here.