Chart value color binding

What is Color Binding

Instead of static colors, a series color can be calculated using a condition based on the data.
With Color Bindings, you configure a condition, so that when Field = Value then the color is applied.

Example

On a Column Chart with a blue series :

… you want the color to become red in some conditions :

Enabling Color Binding

Edit the Series Settings, in tab Advanced, check Color Bindings to enable the feature :

Selecting a field

Select a Color Field from the existing fields in the chart query, or click the + icon to add a new aggregated field to the query :

Select the desired aggregation and field, and click the check icon to validate :

Managing conditions

Based on the selected field, several conditions can be configured : Field = Value1, Field = Value2, …

Adding a condition

Click the + icon on top of the list to add a condition :

Configuring a condition

Configure a Data Value and a Target Color so that when Field = DataValue, then the color of the series turns into Target Color :

Removing a condition

If you wish to remove a condition from the list, select it by clicking it, then remove it using the trash icon :

Supported Chart Types

Some Chart Types like Line only show this value color when Show Marker is configured.

The following chart types don’t support value color binding :

• Spline
• Step Line
• Area, Stacked Area, 100% Stacked Area
• Spline Area
• Step Area
• Bubble
• Scatter
• Range Area
• Hi Lo
• Hi Lo Open CLose
• Candle
• Waterfall
  

Code192 2020 All rights reserved