Skip to main content

Create a combo chart

Combine columns and lines in one Studio chart, with a second axis for metrics on a different scale.

Use a combo chart to show two or more metrics together when they use different scales, for example daily load count as columns and revenue as a line.

Build the combo chart

  1. In the Gadgets tab, click Combo.

  2. Click Add a metric and pick your first metric, for example Load Count.

  3. Click Add metric and pick your second metric, for example Total Revenue.

  4. Click Advanced, then click the second metric and choose Settings... from its menu.

  5. Under Display options, set Draw as to Columns, Bars or Line.

  6. Turn on Own axis so the metric gets its own scale.

  7. Turn on Axis on the right to place that scale on the right-hand side.

    Combo chart with Load Count columns and an average line on the left axis and Total Revenue as a line on its own right axis
  8. Click Save, then save the report or dashboard.

Add reference lines

Each metric's Display options also include:

  • Average line, a dashed line at the metric's average.

  • Trend line, showing the overall direction.

  • Axis minimum, Axis maximum and Minimum visible range to control the scale.

If one metric looks flat along the bottom of the chart, it shares an axis with a much larger metric. The first metric always uses the shared axis, and its Shared axis on the right setting only moves that axis to the right-hand side. To give a metric its own scale, open the settings of the second or a later metric and turn on Own axis.

What's next

Did this answer your question?