Combo charts are based on a single independent variable (usually the x-axis) and up to four dependent variables (usually the y-axes). The dependent variables can be plotted using either bar or line visual styles. The independent variable (x-axis) can be any attribute or metric in the data; the dependent variables (y-axes) must be a metric (numeric field). A single attribute (independent variable) and two metrics (dependent variables) are required.
Note: To edit the number or date and time format for this visual, see Configure Number Formatting for Visuals and Configure Date and Time Formatting for Visuals.
The legend on a combo chart is interactive. It allows you to show or hide different plots on the chart. By default, the plots for all of the metrics on the combo chart are shown. If you select one of the metrics in the legend, its name is grayed out and its plot is removed from the chart. To see its plot again, select the metric in the legend again. In the following example, the plot for the Planned Sales (Sum) metric is not shown on the chart and its name is grayed out in the legend. Adjust metric label visibility, values displayed, and positioning as needed.
a combo chart with multiple axes and options enabled
Combo charts are supported by all Composer data connectors. This topic describes:

Configure Settings for a Specific Combo Chart

Change the settings for a specific combo chart
  1. Edit the combo chart you want to modify. See Edit Visuals.
  2. If you are editing the visual in a dashboard, select Settings from the chart drop-down menu. The sidebar menu for the visual appears.
If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.
  1. Select on the sidebar menu. The Combo Chart Settings sidebar for the visual appears.
Use this work area to define settings for the combo chart visual
  1. Alter settings as needed:
SettingDescription
Enable Y3Use this switch to enable or disable the third dependent variable (on the Y3 axis) on the combo chart. When disabled, the Y3 variable is not plotted.
Enable Y4Use this switch to enable or disable the fourth dependent variable (on the Y4 axis) on the combo chart. When disabled, the Y4 variable is not plotted.
Y1 Axis Visual StyleUse the drop-down list to select a visual style for the Y1 axis variable. Select Bar, Line, or Cumulative Line. Enable Use Percentage Axis to display as a percentage.
Y2 Axis Visual StyleUse the drop-down list to select a visual style for the Y2 axis variable. Select Bar, Line, or Cumulative Line. Enable Use Percentage Axis to display as a percentage.
Y3 Axis Visual StyleUse the drop-down list to select a visual style for the Y3 axis variable. Select Bar, Line, or Cumulative Line. Enable Use Percentage Axis to display as a percentage.
Y4 Axis Visual StyleUse the drop-down list to select a visual style for the Y4 axis variable. Select Bar, Line, or Cumulative Line. Enable Use Percentage Axis to display as a percentage.
Show Metric LabelsEnable to display labels for metric values.
Absolute ValuesEnable to display the data in absolute values.
Relative ValuesEnable to display the data in relative values.
Group Labels PositionSelect a position option for the metric labelsOutside horizontal, Outside diagonal, or Outside vertical.
5. Select to save the dashboard and the visual with its updated settings.

Configure Colors for a Specific Combo Chart

Specify the color settings for a specific combo chart using the Color sidebar
  1. Edit the visual you want to modify. See Edit Visuals.
  2. If you are editing the visual in a dashboard, select Settings from the visual drop-down menu. The sidebar menu for the visual appears. If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.
Select on the sidebar menu. The Color sidebar for the visual appears.
  1. Configure the color settings as described below. As you change the color settings, the legend at the top of the Color sidebar shows how the legend will appear on the visual. Supported color specifications are described in Specify Colors.
SettingDescription
Legend

Enable or disable to display a dynamic legend in this visual. Dynamic legends allow you to temporarily add or remove data shown in the visual.

  • For distinct color styles, select a data point in the legend to turn it off and on in the visual.

If available, enable or disable a static legend for this visual.

Color SettingsSelect colors for the Y2, Y3, and Y4 dependent variables plotted on the combo chart.
Y1 Axis Color PaletteSelect the color palette for the Y1 axis for this specific combo chart.
Inherit from themeSelect this checkbox to use the color palette specified by the theme.
4. Close the Color sidebar and the color settings are dynamically applied to the visual.
  1. Select to save the dashboard and the visual with its updated settings.