This feature is available in Macrobond 1.24 and later.
- How to create a simple heatmap?
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.
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:
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.
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.
In this example, we applied conditional formatting rules based on range of colors to the Bar chart creating a heatmap.
No, formatting works only within columns or whole chart.