Skip to main content
A combo chart plots values over time using more than one representation, typically columns for one measure and a line for another. Use it when you want to compare measures of different scale or unit on a single chart, such as revenue as columns against gross margin percentage as a line. Because the two measures rarely share a scale, a combo chart carries two y-axes.

​
Settings

Click a chart to open its settings, grouped in the sidebar. Remove a group with the X next to its name to hide that element from the chart, and use + to add a series or a target.

​
Chart

The span of data the chart shows. Choose a dynamic range (Last month, YTD, LTM, Full year, Last year, or Next year) or set a Custom range. Dynamic ranges resolve against the Last close date set for the model, so they roll forward automatically as you close each period.
How periods group along the x-axis: monthly, quarterly, calendar year, fiscal year, or all.
The color palette applied to the series. Options are Ocean blue, Olive green, Sun burst, Death star, Pastel, Nature, Temperature, Dawn, Blue, Green, Orange, Red, Pink, Purple, and Gray. Override the palette on an individual series from the series settings.
Whether the line is Smooth or Straight.

​
Series

The series shown in the chart, each drawn from a row, group, or calculation in your model. For each series you can include multiple sources, such as actuals, budget, or forecast. Series order sets the legend order: the top series shows first, then the next, and so on. Sources are styled automatically: actuals render in the full series color, and budget or forecast render semi-transparent as columns and dashed as a line. Click a series to reveal its own settings. When a series has a single source, click the series directly. When it has multiple sources, click the specific source to open its settings.
Whether the series renders as a column or a line. This also fixes the axis: columns always plot against the primary y-axis and lines always against the secondary. To move a measure to the other axis, change its type.
The series name. Defaults to the name of the row, group, or calculation the series is drawn from; override it to rename the series.
Override the palette color assigned to this series.
Show or hide the value labels on the series.
Plot the absolute value of each point, ignoring sign.

​
Title

The chart title. Defaults to the name of the row, group, or calculation the chart is drawn from; override it with free text.
Position the title to the left, center, or right.

​
Legend

Where the legend sits. Top is the only position available for this chart type.

​
X-axis

Show or hide the x-axis line.
Rotate the x-axis labels by 0, 15, 30, 45, 60, 75, or 90 degrees.

​
Primary y-axis

The left-hand axis, scaled to the measure shown as columns.
The axis title, as free text.
Show or hide the axis line.
Auto inherits the unit from the series in the model, or override it with number, percentage, or a currency (DKK, EUR, USD, or GBP).
By default the axis fits the bounds of the series. Set a fixed minimum and maximum to lock the scale.

​
Secondary y-axis

The right-hand axis, scaled to the measure shown as a line. Same settings as the primary axis, applied independently, which is what lets a percentage sit alongside a currency amount without flattening either.
The axis title, as free text.
Show or hide the axis line.
Auto inherits the unit from the series in the model, or override it with number, percentage, or a currency (DKK, EUR, USD, or GBP).
By default the axis fits the bounds of the series. Set a fixed minimum and maximum to lock the scale.

​
Target

The target’s name.
The value the line sits at.
The color of the line.

​
See in action

See charts in practice in the Management report masterclass.