Show a value on a fixed arc against its minimum, maximum and target, as one gauge or a grid of them. Upload a spreadsheet and publish it for free.
A gauge chart reads a single number against a fixed range, the way a speedometer does. The value is drawn as an arc that fills from the minimum toward the maximum, with the number in the middle and an optional marker for the target. Give it several rows and it lays out a grid of gauges, so a small KPI board fits on one canvas. Coloured bands can mark poor, fair and good ranges, and a needle can point at the value. The range is a setting rather than data, so every gauge is judged against the same frame.
Up to about eight gauges make a readable dashboard in one embed.
Percentages, scores and utilisation figures fit a fixed scale from zero to a maximum.
A gauge is instantly familiar, which helps when the audience is not used to charts.
A mark on the arc shows how far each value is from where it should be.
A gauge spends a lot of ink on one number. Past a handful, a bullet chart says the same in less space.
A bullet chart or a bar chart makes close comparisons easier than arcs do.
A gauge needs a minimum and maximum that mean something.
A gauge shows one moment. Use a line chart for a trend.
D’un tableur à un graphique publié, étape par étape.
Each gauge shrinks as the grid grows. Keep to a handful, or switch to a bullet chart.
A maximum far above every value leaves the arcs nearly empty. Pick a range that fits.
Gauges share one scale, so percentages and counts do not belong on the same board.
Labels are truncated to fit under each gauge. Keep names short.
A chart that shows a single value on a fixed arc, like a speedometer, usually with a target and coloured bands.
Gratuit pour commencer, avec plus de 300 modèles. Sans carte bancaire.
