All toolsChart Types

Heatmap Chart

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.

Monthly Returns Heatmapheatmap

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.

The colour scale is everything

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.

Read more
Perceptual uniformity matters more than most people realise. Rainbow palettes, though colourful, distort magnitude because the eye does not perceive their steps evenly, so equal value differences look unequal. Modern heatmaps favour perceptually uniform scales where a fixed change in value always produces the same perceived change in colour, keeping the visual honest across the whole range.

Reading seasonality and outliers

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.

How Quadesto computes it

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.

Build this with your own data

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 account

Frequently asked questions

What is a heatmap used for?
A heatmap displays a two-dimensional grid of values as colour, making patterns easy to scan. In finance it is common for monthly returns by year, correlation matrices and calendar seasonality, where colour reveals streaks, outliers and structure that a numeric table would obscure.
How do I read a returns heatmap?
Rows and columns index the two dimensions — often years and months — and each cell's colour shows the return, typically red for losses and green for gains. Scan columns for months that are consistently strong or weak, and rows for good or bad years, then look for standout outlier cells.
What colour scale should a heatmap use?
For data centred on zero, such as returns, use a diverging scale with a neutral midpoint and two contrasting hues. For one-directional data use a single-hue sequential ramp. Prefer perceptually uniform palettes so equal value changes always look like equal colour changes.
How is a heatmap different from a correlation matrix?
A correlation matrix is one specific heatmap whose cells hold pairwise correlations from −1 to +1. A heatmap is the general technique of colouring any grid of values — returns, volumes, scores — so the correlation matrix is a special case rather than a different chart type.
Can I build a heatmap from my own data?
Yes. Upload data with a row key, a column key and a value to Quadesto, and the engine pivots it into a grid and renders a colour-coded heatmap with a scale you can centre where you like. The chart embeds into research notes and reports.