Skip to main content

Mixed Chart

A mixed chart draws bars and a line on the same chart. It is the right choice when you want to show two related but differently-scaled metrics together — for example a volume as bars and a rate or running value as a line.

When to use it​

  • A count (bars) alongside a percentage or average (line).
  • An absolute total (bars) alongside a cumulative or trend value (line).
  • Any time two series share an x-axis but look wrong on the same scale.

Building a mixed chart​

Provide your labels in the first column, then the numeric series:

SELECT
  month            AS "Month",
  SUM(revenue)     AS "Revenue",
  AVG(margin_pct)  AS "Avg margin %"
FROM monthly
GROUP BY month
ORDER BY month;

Choose Mixed as the chart type. Revenue is shown as bars and Avg margin % as a line over the top, so the large total and the small percentage stay readable side by side.

Tips​

  • Keep the bigger-magnitude series as the bars and the smaller/rate series as the line.
  • Order the labels with ORDER BY so the line reads correctly.
  • Don't overload it — one bar series and one line series is the clearest combo.