Skip to main content Skip to complementary content

Creating combo charts

The combo chart is suitable for comparing two sets of measure values that are usually hard to compare because of the differences in scale. It is basically a bar chart combined with a line chart.

You can create a combo chart on the sheet you are editing. In a combo chart, you need at least one dimension and one measure.

  1. In a sheet, click to add a new visualization.
  2. Under Visualization, select Vertical combo chart or Horizontal combo chart.
  3. Click and drag a field or master item under Data as a dimension.
  4. Click and drag a field or master item under Data as a measure for the length of bars.
  5. Click and drag a field or master item under Data as a measure for the height of line.
  6. Optionally, you can change the presentation of measures to bars, lines, or markers, In the advanced edit mode, under Measures, select More Properties in a measure. Choose the Presentation of the measure. You can select drop-down options to switch between the Primary axis to the left or the Secondary axis to the right (right and left axes are reversed if Right-to-left is turned on in App settings). For markers you can choose between several different shapes.

You can only have one dimension, but you can continue adding up to 15 measures. You can only have two measure axes though. This means, if you add three or more measures with a large difference in value range it can be hard to display all measures with a good distribution of values.

When you have created the combo chart, you might want to adjust its presentation in standard edit mode. For more information, see Presentation properties.

You can also change the chart's appearance in the advanced edit mode. For information about styling see Styling the combo chart. For information about customizing other aspects of the chart's appearance, see Changing the appearance of a visualization.

Styling the combo chart

With Advanced options turned on, you have a number of styling options available under Appearance in the properties panel.

Click Styling under Appearance > Presentation to further customize the styling of the chart. The styling panel contains various sections under the General and Chart tabs.

You can reset your styles by clicking next to each section. Clicking Reset all resets styles in both General and Chart.

For general information about styling an individual visualization, see Applying custom styling to a visualization.

Customizing the text

You can set the text for the title, subtitle, and footnote under Appearance > General. To hide these elements, turn off Show titles.

The visibility of the labels shown on the chart depends on how you configure the measure values to be displayed, as well as other chart-specific settings and label display options. Configure a measure to be shown as Bars, Line, or Marker by expanding the measure under Data > Measures, and clicking More properties. Configure additional chart and label options under Appearance > Presentation.

You can style the text that appears in the chart.

  1. Click Advanced options.

  2. In the properties panel, expand the Appearance section.

  3. Under AppearancePresentation, click Styling.

  4. On the General tab, set the font, emphasis style, font size, and color for the following text elements:

    • Title

    • Subtitle

    • Footnote

  5. On the Chart tab, expand the Bars section.

  6. Under Bar labels, style the labels for measure values configured as Bars. You can select the font, font size, and color.

  7. Expand the Lines section of the Chart tab.

  8. Under Point labels, style the labels for measure values configured as Line. You can select the font, font size, and color.

  9. On the Chart tab, set the font, font size, and color for the following text elements:

    • Axis title: Style the titles on the axes.

    • Axis label: Style the labels on the axes.

    • Legend title: Style the title of the legend.

    • Legend labels: Style the labels of the individual legend items.

Customizing the background

You can customize the background of the chart. The background can be set by color and image.

  1. Click Advanced options.

  2. In the properties panel, expand the Appearance section.

  3. Under AppearancePresentation, click Styling.

  4. On the General tab of the styling panel, you can select a background color (single color or expression), and also set the background to an image from your media library.

    When using a background color, use the slider to adjust the opacity of the background.

    When using a background image, you can adjust image sizing and position.

Customizing the bar segment outline and bar width

If your combo chart contains measure data represented as bars, you can adjust the outline surrounding each bar segment in the chart, as well as the width of the bars.

  1. Click Advanced options.

  2. In the properties panel, expand the Appearance section.

  3. Under AppearancePresentation, click Styling.

  4. On the Chart tab, expand the Bars section.

  5. Under Outline, set the thickness and color of the outlines.

  6. Adjust the slider for Bar width to set the width of the bars.

Customizing the lines and data points

If your combo chart contains measure data represented as lines, you can customize the appearance of the lines and data points in the chart.

  1. Click Advanced options.

  2. In the properties panel, expand the Appearance section.

  3. Under AppearancePresentation, click Styling.

  4. On the Chart tab, expand the Lines section.
  5. Under Data point size, adjust the slider to change the size of the data points in the chart.

  6. Under Line options, adjust the line thickness, line type (solid or dashed), and line curve (linear or monotone).

Customizing the border and shadow

You can customize the border and shadow of the chart.

  1. Click Advanced options.

  2. In the properties panel, expand the Appearance section.

  3. Under AppearancePresentation, click Styling.

  4. On the General tab of the styling panel, under Border, adjust the Outline size to increase or decrease the border lines around the chart.

  5. Select a color for the border.

  6. Adjust the Corner radius to control the roundness of the border.

  7. Under Shadow in the General tab, select a shadow size and color. Select None to remove the shadow.

Related learning:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!