Encode a two-dimensional grid of values as colour to expose patterns fast.
What is a heatmap chart?
A heatmap encodes the values of a two-dimensional grid as colour, so magnitude is read by shade rather than by number. In finance a classic use is a monthly-returns table, with years down one axis and months across the other, each cell coloured from red for losses to green for gains. The colour mapping lets the eye scan hundreds of cells at once, surfacing seasonality, streaks and outliers that a numeric table buries.
Illustrative monthly-returns heatmap across four years. Values are for demonstration only.
Numbers in a grid are hard to compare; colour is not. A heatmap swaps digits for shades, so patterns that hide in a table — a weak month every year, a run of red, a single outlier — leap out. This tool renders four years of monthly returns as a colour grid so you can read the seasonality at a glance.
A heatmap is only as good as its colour mapping. For data centred on a meaningful zero — like returns — a diverging scale with a neutral midpoint and two contrasting hues for gains and losses is essential; it lets a reader separate positive from negative instantly. For strictly one-directional data a sequential single-hue ramp works better. A poorly chosen scale can invent patterns that are not there or hide ones that are.
The monthly-returns heatmap is popular because it makes calendar structure visible. A column that runs consistently green suggests a seasonally strong month; a persistently red row flags a difficult year. A single unusually dark or bright cell is an outlier worth investigating — a crisis, a rally, or a data error. The grid layout invites both across-row and down-column comparison, which is exactly what seasonality analysis requires.
Quadesto pivots your data into a grid from three columns — a row key, a column key and a value — and renders it as a heatmap with a diverging, perceptually uniform colour scale you can centre on any midpoint. The monthly-returns grid above is built from year, month and return triples, and the finished heatmap embeds into performance reviews and research notes.
Upload a CSV or connect a live source, and Quadesto renders this exact chart — styled, computed, and embeddable in your reports and newsletters. Free to start.
Create free accountExplore all free financial tools, browse the finance glossary, or see how teams use Quadesto.