Skip to content

Bars, horizontal

Chart

One bar per category running left to right, the names down the left and each value at its bar’s end — longest first.

Ranking many named things, or things with long names — pages cited per site, tickets per agent, sales per product. The names get the room a bottom axis cannot give them, and the list reads top down. Put ‘show at most’ on it for a top ten.

The question is how something changes over time — a trend reads left to right, so use upright bars or a line.

A column whose values are the categories (a site, a person, a product). A sum or an average also needs a number column.

Describe it in a sentence — for example “cited pages per site, biggest first”.

An assistant connected to Routario over MCP (Claude, ChatGPT) makes it with chart_create, then puts it on a board with dashboard_tile_add.

  • Subtitle — One line under the title. What the reader should take from it.
  • Along the bottom — The column whose values become the slots along the bottom — a date for a trend, a category for a comparison.
  • Grouped by — Only applies when the column along the bottom is a date: which stretch of time each slot covers.
  • Series — Each series is one measure, optionally narrowed to the rows that match a condition.
  • Measure — What each series computes over the rows in a slot.
  • Unit — For ‘time between two dates’: the unit the gap is measured in.
  • Aggregate — For ‘time between two dates’: how several rows’ gaps become one number.
  • Where — Narrows one series to the rows matching a condition — how several series share one axis.
  • Colour — A plain colour picks a pigment and says nothing about the data. A named meaning — went well, needs attention, went wrong — tells the reader something they will believe.
  • Show numbers as — How the value axis, the tooltips and the printed values spell a number.
  • Show dates as — Only applies to a date axis; anything else is left exactly as stored.
  • Targets — A flat line at a goal, a floor or an SLA the chart is judged against. Not something the data produced.
  • Good side of the target — Which side of the target is good — it colours how far a number is from it.
  • Legend — Where the series names sit, if anywhere.
  • Value axis — Whether the numbers up the side are drawn. On unless switched off.
  • Gridlines — Whether the faint lines across the plot at each value step are drawn. On unless switched off.

Auto-generated from the tile registry (core/custom_tables/tile_registry.py) — the same text the chart editor and the AI drafter read. Do not edit by hand.