Edilitics | Data to Decisions

Heatmap

Show how a measure varies across two categories at once, shaded by intensity in a grid. Best for spotting hot and cold spots across a matrix of combinations.

A heatmap shows a single measure across two categorical dimensions at once, as a grid of color-shaded cells. Drop exactly two categorical or date fields into Column - the first becomes the X-axis, the second the Y-axis - and exactly one numeric field into Row to drive the color. Use it when the question is "which combination of these two categories stands out," not when you need to read exact numbers.

When to Use

A heatmap trades exact-number precision for at-a-glance pattern recognition across two dimensions simultaneously - day of week against hour of day, region against product category, agent against ticket type. Every cell's color tells you roughly how high or low that combination is relative to the rest of the grid, so a hot spot or dead zone jumps out without scanning a table row by row.

Field order decides axis placement. The first dimension field you assign becomes the X-axis along the bottom, the second becomes the Y-axis along the side. There's no swap control after the fact - if the grid looks rotated from what you intended, reassign the fields in the order you want them to appear.

Switch to a different chart when:

  • You need exact numbers alongside the magnitude cue, not just color - use Highlighted Table
  • You have one dimension, not two, to shade by value - use a Highlighted Table with a single column
  • You want to see the shape of a single measure's distribution, not a two-dimension comparison - use a Histogram
ScenarioX-Axis DimensionY-Axis DimensionMeasure
Support ticket volume by day and hourHour of dayDay of weekCount of tickets
Website engagement by page and devicePageDevice typeAverage session duration
Sales performance by region and product lineProduct lineRegionRevenue
Server load by service and time windowTime windowService nameAverage CPU utilization
Survey sentiment by question and respondent groupQuestionRespondent groupAverage score

Required Inputs

FieldTypeCount
DimensionCategorical or DateExactly 2
MeasureNumericExactly 1

For step-by-step build instructions, see Build Your First Chart.

Formatting Options

The Format tab unlocks after both dimension fields and the measure are assigned.

Style

Use the chart title to state what the grid compares, since two-axis category labels alone don't always make the relationship obvious.

ControlWhat it does
Show Chart TitleShows or hides the title.
Enter Chart TitleTitle text. Maximum 50 characters.
Font familyFont applied to the title.
Font size5 to 30.
Bold / ItalicWeight and style.
AlignmentLeft, center, or right within the chart container.

Heatmap Styles controls the grid cells' border and the in-cell value labels, in one place.

ControlWhat it does
Border ColorColor of the thin line separating each cell from its neighbors.
Show LabelsPrints each cell's exact value on top of its color. Off by default on dense grids, since labels can crowd small cells.
Font Family / Color / Font size / Bold / ItalicStyling for the in-cell labels, when shown. Font size up to 18.
Number TypeDefault, Scientific, Decimal, or Percentage, for the in-cell labels.
Display UnitNone, Thousand, Million, or Billion, for the in-cell labels.
Decimal Places0 to 6. Only shown when Number Type isn't Default.

Data Label is a second path to the same in-cell labels controlled in Heatmap Styles above - the Show toggle and styling here write to the same settings. The Vertical Position control in this panel has no visible effect on a heatmap, since cell labels always render centered inside each cell regardless of this setting.

ControlWhat it does
Show Data LabelsSame toggle as Heatmap Styles' Show Labels.
Font Family / Color / Font size / Bold / ItalicSame styling as Heatmap Styles.
Number Type / Display Unit / Decimal PlacesSame number formatting as Heatmap Styles.

Axes

Axis Name labels what each axis represents - the dimension field's name by default, editable per axis.

ControlWhat it does
Show Axis NameShows or hides the axis title. Falls back to the assigned field's name in Title Case when no custom label is set.
Custom labelOverrides the automatic field-name label for that axis.
Font Family / Color / Font sizeStyling for the axis name text.

Axis Line controls the visibility and color of the line each axis sits on.

ControlWhat it does
Show Axis LineShows or hides the line itself.
Line ColorColor of the axis line.

Axis Label controls the category names printed along each axis - the X-axis categories along the bottom, the Y-axis categories along the side.

ControlWhat it does
Show Axis LabelShows or hides the category labels.
Font Family / Color / Font sizeStyling for the labels.
Text CaseUppercase, lowercase, capitalize, or none.
Max LengthTruncates long Y-axis category names with an ellipsis. The chart also auto-shrinks this based on available space, so labels rarely overflow even without a manual value.

Y-axis label truncation is automatic by default - the chart calculates how much horizontal space labels can use based on chart width and font size, then truncates to fit. Max Length only needs to be set manually if you want a stricter limit than the automatic calculation provides.

Interactivity

Visual Map is the color legend that defines the heatmap's color scale - and the one panel unique to color-scaled chart types like this one.

ControlWhat it does
Show Visual MapShows or hides the color legend entirely. The color scale still applies to the cells either way - this only controls the legend's visibility.
OrientationVertical or horizontal placement of the legend.
Vertical / Horizontal PositionWhere the legend sits within the chart area.
Interactive RangeWhen on (default), viewers can drag the legend's handles to narrow the highlighted value range, fading out cells outside it without changing the data.
Low Value ColorThe gradient's low end.
High Value ColorThe gradient's high end.

The scale's min and max are always calculated automatically from the data currently in the grid - there is no manual override. If you filter the data, the color scale recalculates against the new range, so the same value can shade differently before and after a filter.

The tooltip appears on hover over any cell, showing both category values and the cell's exact measure value.

ControlWhat it does
Show TooltipShows or hides the tooltip entirely.
Header / value text stylingFont, size, and color for the category and value lines shown in the tooltip.

Animation controls the grid's transition when the chart first renders or the data changes.

ControlWhat it does
Enable AnimationTurns the transition animation on or off.
DurationHow long the transition takes.
DelayHow long the transition waits before starting.
Easing FunctionThe transition curve.

Emphasis controls the visual response when hovering over a cell - a scale-up effect and a drop shadow. Off by default.

ControlWhat it does
Show EmphasisTurns hover effects on.
Focus TypeItem, Series, or None.
Enable ScaleScales the hovered cell up slightly.
Scale Size1.0x to 2.0x.
Shadow Blur / Color / Offset X / Offset YDrop shadow styling on the hovered cell.
Border WidthBorder added around the hovered cell.

Enable the Toolbox when viewers need to export the heatmap or inspect its underlying data.

ControlWhat it does
Show ToolboxShows or hides the toolbox icon bar.
Save as ImageAdds a download icon that saves the heatmap as a PNG.
Data ViewAdds an icon that opens the underlying data table in a separate view.

Best Practices

Assign dimensions in the order you want them to appear. The first Column field becomes the X-axis, the second becomes the Y-axis, with no swap control afterward. If the grid reads backwards from what makes sense for your audience, reassign the fields rather than trying to fix it in formatting.

Reserve in-cell labels for grids small enough to read them. A 5-by-5 grid can comfortably show exact values on top of the color; a 30-by-30 grid cannot. Use Show Labels in Heatmap Styles only when the cell count is small enough that the numbers stay legible.

Pick a gradient with enough contrast to read at a glance. The default sequential theme gradient works for most cases, but if your low and high values need to be unmistakably different, set Low Value Color and High Value Color in Visual Map to two clearly distinct colors rather than two shades of the same hue.

Don't expect the color scale to stay stable across filtered views. Because min and max are recalculated from whatever data is currently in the grid, the same value can shade differently before and after a filter is applied. A heatmap is not a reliable way to compare color across two different filtered views of the same data - use Interactive Range to explore one view at a time instead.

Use a heatmap only when both axes are genuinely categorical or date-based. A heatmap's two dimensions must be exactly two fields - if your real comparison needs more than two grouping dimensions, a heatmap can't represent that, and a Highlighted Table with multiple measure columns is the better fit.

FAQs

Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.

Last updated on

On this page