Combo chart
- Helen Gosper
- Denise McGettigan
Availability:
Summary view - All modes except for Transaction and Total.
Focused view (when you select and focus on items in a dimension) - Variance and Stream mode only.
A Combo chart combines a Column chart and a Line chart. One data set, such as a period or stream, is represented by blue columns (bars) and the data set variable is represented by a set of red points connected by straight lines. The use of different elements (bar and line) makes it easier to visualize two distinct sets of data.
Combo charts are useful for simple comparisons involving more than one data set, such as different years. For example, you might want to compare sales against the budget or the performance of Sales Reps this calendar year to date (YTD) against last calendar YTD.
The following table describes what the Combo chart looks like in each view.
| Summary view | Focused view |
|---|---|---|
Contents | There is a blue column for the current period (or stream) and a red line for the previous period (or other stream). | There is a column/line for each of the focused items. |
X-axis | The X-axis displays the time units of your current period. | The X-axis displays each focused item. |
Y-axis | The Y-axis displays the total, which starts at zero. | The Y-axis displays the total, which starts at zero. |
Example | 
| 
|
Example - Create a Combo chart
In the Sales database, create a Combo chart to compare the performance of all Sales Reps for the current financial year to date with the previous year.
Prepare the data in the grid:
Select the Sales Rep dimension.
Select Mode > Variance.
Select Period > Financial YTD.
Click the Chart button in the top right toolbar above the grid. The Bar chart type displays by default.
Click the Bar chart category button on the left of the chart and select the Combo option.
You can now compare the sales for each Sales Rep this year to date (blue columns) with that of last year (red line).
(Optional) Save the chart as a favorite or add it to a dashboard.