Heatmap

This feature is available in Macrobond 1.24 and later.

You can create a Heat map by modifying Bar chart in a way that presents values by assigning them a color from defined range of colors - using Bar chart conditional formatting rules.

How to create a simple heatmap?

Color ranges

To set a three-colors rule you need to define two ranges of colors. For example: 0 to 50th percentile as a range from red to yellow, and 50th to 100th percentile as a range from yellow to green. This way you will receive a heat map showing the highest percentile in green, lowest in red and all others in the colors range accordingly to their values.

Applying to series

You may apply a rule to all visible values in the table, or for each column separately.

You may also decide to which columns apply the rule:

Multiple rules

In one Bar chart you can have different rules for different columns.

Each column is a separate category, and the same rule will apply to each column’s values range separately.

Using other series for formatting

You may use other series to define the range of values of plotted series, even the one not used in the chart, by setting Value series to this series.

Example: You have one series with the values and another with a condition

  • ‘0’ value if the change was negative and ‘1’ if it was positive

And you want to show the actual values but color them using the condition series.

More information about Bar charts and Conditional formatting rules you will find under below links:
Bar chart
Bar chart conditional formatting rules

Example

Heatmap

In this example, we applied conditional formatting rules based on range of colors to the Bar chart creating a heatmap.

Questions

Can I format within a row instead of a column?

No, formatting works only within columns or whole chart.