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:
| Option | What it does |
|---|---|
| Name | The metric name in the legend, tooltip and automatic axis title. For example, "Average result (%)". |
| Value format | How the number is displayed: Default, Number, Percent, Duration, Bytes, Bits or Custom. |
| Decimals | Decimal places (in the Number and Percent formats). |
| Suffix | Text after the number, such as %, °C, kg or days. |
| Compact values | Abbreviates large numbers (12.5K instead of 12,480). |
| Series color | The series color, as a hex code (for example, #2E7D32). |
| Axis side | The series axis: Auto, Left or Right. |
Which format to use
| The value is… | Format | Example |
|---|---|---|
| A quantity | Number, 0 decimals | 214 audits |
| A percentage already in 0–100, coming from the form | Number, 1 decimal, % suffix | 85.3% |
| A rate calculated by division, in 0–1 | Percent, 1 decimal | 25.0% |
| A measure with a unit | Number, with suffix | 3.8 °C · 22.4 kg · 1,523.4 h |
| A time in seconds or minutes | Duration | 5 min 12 s |
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.
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).
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:
| Option | What it does |
|---|---|
| Axis title | Axis title: None, Auto or Custom. |
| Gridlines | Background grid lines. |
| Tick labels | The values written on the axis. |
| Orientation | Label angle (horizontal, vertical or diagonal), useful for long names. |
| Bounds | Axis limits: Full (starts at zero), Data (fits the data) or Custom (set minimum and maximum). |
| Scale | Linear or logarithmic scale. |
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.
- In the metric, under Color, choose Dynamic (or enable Color by value, in tables).
- Click Edit to open the ranges.
- Choose whether the ranges are in Number (indicator values) or Percent (percentage of the scale).
- 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:
| Range | Reading | Suggested color |
|---|---|---|
| Below 60 | Critical | Red #E53E3E |
| 60 to 70 | Attention | Yellow #ECC94B |
| 70 to 80 | On target | Light green #9AE6B4 |
| 80 to 85 | Above target | Green #48BB78 |
| 85 or more | Outstanding | Dark green #2F855A |
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
- One color per series, the same in every chart of the dashboard.
- Red, yellow and green only to indicate status against the target.
- Units in the title or metric name: %, days, occurrences, °C.
- Same decimals for the same indicator across the dashboard.
- Readable labels for fields, axes and legends.
- Percentage axes from 0 to 100.
- Legends below the chart, when there is a breakdown.
- Titles with the time range when a chart uses a range different from the dashboard ("year to date", "last 12 months").