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.
A typical example is when you have a bar chart with sales figures and want to combine these figures with the margin values (in percent). In a regular bar chart, the bars for sales would be displayed as usual, but the margin values would be almost invisible because of the very large difference between the numeric values for sales and margin.
A combo chart with the margin values (in percent) and bars with sales figures.
With a combo chart you can combine these values by, for example, using bars for the sales values and a line for the margin values. By default, the bars have the measure axis on the left and the margin values have a separate axis to the right. The two measures use the same dimension (YearMonth).
If you have yet another measure, for example, gross sales, with values that are roughly in the same range as the sales values, you can add the third measure as bars and either stack or group the new measure values with the sales values. Mit gruppierten Balken können Sie einfach zwei oder mehr Elemente in der gleichen Kategoriegruppe vergleichen. Gestapelte Balken kombinieren Balken verschiedener Gruppen, die übereinander dargestellt werden. Die Gesamthöhe des resultierenden Balkens stellt das kombinierte Ergebnis dar.
A combo chart with three measures; the margin values (in percent), bars with sales figures and the measure Gross sales grouped with the sales values.
The combo chart can only be displayed vertically.
When to use it
With the possibility to have different measure scales, one to the left and one to the right, the combo chart is ideal when you want to present measure values that are normally hard to combine because of the significant difference in value ranges.
But a combo chart can also be quite useful when comparing values of the same value range. In the image above, the combo chart only has one measure axis, but the relationship between the two categories sales and cost is clear.
Advantages
The combo chart is the best choice when combining several measures of different value ranges.
Disadvantages
The combo chart only supports one dimension, and can therefore not be used when you need to include two or more dimensions in the visualization.
Creating a combo 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.
Gehen Sie folgendermaßen vor:
- From the assets panel, drag an empty combo chart to the sheet.
- Klicken Sie auf Dimension hinzufügen und wählen Sie eine Dimension oder ein Feld aus.
- Klicken Sie auf Hinzufügen und wählen Sie eine Kennzahl aus oder erstellen Sie eine Kennzahl aus einem Feld. Select to show the measure as a bar.
- Add another measure by selecting Add under Height of line. Enter an expression, or master measure item, or a field with an aggregation function applied. By default a line will appear as the measure.
-
When you are done adding measures, configure each measure to display as bars, lines, or markers. For more information, see Configuring the presentation of measures.
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 appearance and other settings in the properties panel. 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
Unter Darstellung im Eigenschaftsfenster sind mehrere Designoptionen verfügbar.
Klicken Sie auf 
Design unter Darstellung > Präsentation, um das Design des Diagramms weiter anzupassen. Das Designfenster enthält mehrere Abschnitte auf den Registerkarten Allgemein und Diagramm.
Sie können Ihre Designs zurücksetzen, indem Sie auf 
neben den einzelnen Abschnitten klicken. Wenn Sie auf Alle zurücksetzen klicken, werden die Designs für alle verfügbaren Registerkarten im Designfenster zurückgesetzt.
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.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click
Styling. -
Legen Sie auf der Registerkarte Allgemein die Schriftart, den Hervorhebungsstil, die Schriftgröße und die Farbe der folgenden Textelemente fest:
-
Titel
-
Untertitel
-
Fußnote
-
-
On the Chart tab, expand the Bars section. This section appears if any of the measures are being displayed as bars.
-
Under Bar labels, style the labels for measure values configured as Bars. You can select the font, font size, and color.
Wenn Sie die Präsentationsoption Gestapelt verwenden, steuert diese Einstellung Segmentbezeichnungen (Kennzahlenwerte für jeden Dimensionswert) und Gesamtwertebezeichnungen (kombinierte Kennzahlenwerte für jeden Dimensionswert).
-
Expand the Lines section of the Chart tab. This section appears if any of the measures are being displayed as lines.
-
Under Point labels, style the labels for measure values configured as Line. You can select the font, font size, and color.
-
On the Chart tab, expand the Markers section. This section appears if any of the measures are being displayed as markers.
-
Under Marker labels, style the labels for measure values configured as Marker. You can select the font, font size, and color.
-
Legen Sie auf der Registerkarte Diagramm die Schriftart, die Schriftgröße und die Farbe der folgenden Textelemente fest:
-
Achsentitel: Legen Sie das Design der Titel auf den Achsen fest.
-
Achsenbeschriftung: Legen Sie das Design der Beschriftungen auf den Achsen fest.
-
Legendentitel: Legen Sie das Design des Legendentitels fest.
-
Legendenbezeichnungen: Legen Sie das Design der Bezeichnungen für die einzelnen Legendenelemente fest.
-
Customizing the background
You can customize the background of the chart. The background can be set by color and image.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click
Styling. -
On the General tab of the styling panel, you can select a background color (single color or expression). You can also set the background to an image from your media library or from a URL.
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.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click
Styling. -
On the Chart tab, expand the Bars section.
-
Under Outline, set the thickness and color of the outlines.
-
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.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click
Styling. - On the Chart tab, expand the Lines section.
-
Under Data point size, adjust the slider to change the size of the data points in the chart.
-
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.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click
Styling. -
On the General tab of the styling panel, under Border, adjust the Outline size to increase or decrease the border lines around the chart.
-
Select a color for the border.
-
Adjust the Corner radius to control the roundness of the border.
-
Under Shadow in the General tab, select a shadow size and color. Select None to remove the shadow.
Configuring grid line spacing
You can change the placement of grid lines on the chart. Select whether to show grid lines based on the primary or secondary axis, and adjust the spacing. You can also turn off grid lines if desired.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Expand Appearance > Presentation.
-
Toggle Grid line spacing from Auto to Custom.
-
Use the drop down menu to select whether the grid lines are placed along the Primary axis or Secondary axis.
Depending on the scale used by each axis, you might not notice any difference between these settings.
-
Use the second drop down menu to select the spacing, or choose No lines to remove grid lines.
Configuring the presentation of measures
Optionally, you can change the presentation of measures between bars, lines, or markers. Additional options are also available.
Gehen Sie folgendermaßen vor:
-
In the properties panel, under Measures, select More Properties in a measure.
-
Choose the Presentation of the measure. You can:
- Change the presentation of measures between bars, lines, or markers. For markers you can choose between several different shapes.
-
Select drop-down options to switch between the Primary axis or the Secondary axis.
TipphinweisThe primary axis is on the left side of the chart, and the secondary axis in on the right side. Right and left axes are reversed if Right-to-left is turned on in App settings.
Adding bar and marker labels
If any measures in the chart are configured as bars or markers, you can show or hide their value labels. Bar and marker labels can be configured separately from one another.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Presentation, do one or both of the following:
-
Set Bar labels to Auto.
-
Set Marker labels to Auto.
-
Adding segment and total labels
For combo charts with a specific configuration, you can add segment and total labels. Segment labels show values for each measure segment in a chart. Total labels show values for an entire set of measures arranged along a single axis.
You can add segment and total labels if all of the following apply:
-
Two or more measures on the same axis are configured as bars.
-
The combo chart uses the Stacked presentation option. This setting is located under Appearance > Presentation, and only appears if there are two or more bar measures on the same axis.
-
Bar labels are set to Auto.
Gehen Sie folgendermaßen vor:
-
In the properties panel, expand the Appearance section.
-
Under Presentation, set Bar Labels to Auto.
-
Do one or both of the following:
-
Set Segment labels to Auto.
-
Set Total labels to Auto.
-
Display limitations
Displaying out of range values
In the properties panel, under Appearance, you can set a limit for the measure axis range. Without a limit, the range is automatically set to include the highest positive and lowest negative value, but if you set a limit you may have values that exceed that limit. A bar that exceeds the limit will be cut diagonally to show that it is out of range. For a line data point value that is out of range, an arrow indicates the direction of the value.
Displaying large amounts of data in a combo chart
If the chart uses a continuous scale, a maximum of 2000 data points can be displayed. The actual maximum number of data points in the chart is affected by the distribution of the data. Above this actual maximum number of data points, data points are neither displayed, nor included in selections made in the chart.
To avoid displaying limited data sets, you can either make a selection or use dimension limits in the properties panel.
Colors and legend
Wenn Einfärbung nach Dimension in diesem Diagramm verwendet wird, können maximal 100 eindeutige Dimensionswerte und 100 eindeutige Farben auf der Legende aufgetragen werden.