Skip to main content

Formatting and style

Finishing touches are what make a dashboard understood without explanation. Numbers with the right unit, titles that say what the chart shows, colors that instantly indicate what is fine and what needs attention. A well-formatted dashboard is read by an executive in seconds and by a supervisor with no training. A dashboard without finishing forces readers to decipher axes, legends and decimals before reaching the information.


Name and format of each metric​

Click the metric in the editor's configuration panel:

OptionWhat it does
NameThe metric name in the legend, tooltip and automatic axis title. For example, "Average result (%)".
Value formatHow the number is displayed: Default, Number, Percent, Duration, Bytes, Bits or Custom.
DecimalsDecimal places (in the Number and Percent formats).
SuffixText after the number, such as %, °C, kg or days.
Compact valuesAbbreviates large numbers (12.5K instead of 12,480).
Series colorThe series color, as a hex code (for example, #2E7D32).
Axis sideThe series axis: Auto, Left or Right.

Which format to use​

The value is…FormatExample
A quantityNumber, 0 decimals214 audits
A percentage already in 0–100, coming from the formNumber, 1 decimal, % suffix85.3%
A rate calculated by division, in 0–1Percent, 1 decimal25.0%
A measure with a unitNumber, with suffix3.8 °C · 22.4 kg · 1,523.4 h
A time in seconds or minutesDuration5 min 12 s
0–1 or 0–100

The Percent format multiplies the value by 100. A field that already comes as 85 is shown as 8,500%. Use Percent only for values between 0 and 1 (results of divisions) and Number with the % suffix for values between 0 and 100.

Same format for metrics on the same axis

Metrics with different formats go to different axes, one on each side of the chart. If the chart got a second axis by accident, make the metrics' Value format the same.


Titles​

  • Chart title — set when saving or, in the dashboard, in ⋯ → Settings. Use a phrase that says what the chart shows, with the unit and, if useful, the time range: "Average result by site (%) – year to date".
  • Axis titles — in the toolbar, on each axis button, under Axis title: None, Auto or Custom (free text).
Axis titles with the Custom field

The automatic axis title uses the dimension name and may include additions such as "per month". To write the exact title, use Axis title → Custom on the axis button, not the dimension's Name field.


Value labels​

Value labels show the number on each bar or point. In the toolbar, open the labels button (T icon) and, under Value labels, choose Show.

In charts with many bars, labels may overlap. In that case, reduce the number of groups or keep labels only in the main charts.


Legend​

In the toolbar's Legend button:

  • Display — show, hide or automatic.
  • Position — above, below, left or right of the chart. Below (Bottom) usually makes better use of the width.
  • Truncate text — shortens long names to fit the legend.
  • Statistics — in some visualizations, shows each series' value in the legend (current, average, total).

Clicking a legend item hides or shows that series.


Axes​

On each axis button in the toolbar:

OptionWhat it does
Axis titleAxis title: None, Auto or Custom.
GridlinesBackground grid lines.
Tick labelsThe values written on the axis.
OrientationLabel angle (horizontal, vertical or diagonal), useful for long names.
BoundsAxis limits: Full (starts at zero), Data (fits the data) or Custom (set minimum and maximum).
ScaleLinear or logarithmic scale.
Percentages from 0 to 100

For percentage indicators, fix the vertical axis at Custom, from 0 to 100. Every chart in the dashboard then uses the same scale, and a 2-point change doesn't look like a sharp drop.


Colors​

Fixed color per series​

In each metric, Series color sets the series color. Use hex codes to keep the same colors in every chart of the dashboard.

Fixed color per category​

When the chart has a breakdown, each category's color can be assigned in the Breakdown options. Use it so that each status always has the same color (for example, "Approved" in green, "Needs adjustments" in orange and "Rejected" in red) in every chart.

Chart palette​

The breakdown options also let you choose the palette used for categories. In the dashboard settings, Sync color palettes across panels makes charts use the same colors for the same values. See Dashboard settings.

Color by value​

Cards, gauges and table columns can change color according to the value: the traffic light of indicators.

  1. In the metric, under Color, choose Dynamic (or enable Color by value, in tables).
  2. Click Edit to open the ranges.
  3. Choose whether the ranges are in Number (indicator values) or Percent (percentage of the scale).
  4. Set the start of each range and its color. Use Add color to create more ranges.

Example ranges for an indicator with a 70% target:

RangeReadingSuggested color
Below 60CriticalRed #E53E3E
60 to 70AttentionYellow #ECC94B
70 to 80On targetLight green #9AE6B4
80 to 85Above targetGreen #48BB78
85 or moreOutstandingDark green #2F855A
Alert colors only for status

Reserve red, yellow and green to indicate status (below, near or above target). For regular series (sections, sites, months), use other colors. That way, red always means "attention" across the whole dashboard.


Appearance​

In the toolbar's appearance button, depending on the chart type:

  • Fill opacity — area transparency.
  • Line interpolation — straight, curved or stepped line.
  • Missing values — what to do in intervals without collections: leave empty, connect the points or use zero.
  • Show current time marker — marks the current moment in timeline charts.
  • Point visibility — shows or hides line points.

Recommended visual standard​

  1. One color per series, the same in every chart of the dashboard.
  2. Red, yellow and green only to indicate status against the target.
  3. Units in the title or metric name: %, days, occurrences, °C.
  4. Same decimals for the same indicator across the dashboard.
  5. Readable labels for fields, axes and legends.
  6. Percentage axes from 0 to 100.
  7. Legends below the chart, when there is a breakdown.
  8. Titles with the time range when a chart uses a range different from the dashboard ("year to date", "last 12 months").