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.
Do the following:
- In a sheet, click
to add a new visualization. - Under Visualization, select Combo chart.
- Click and drag a field or master item under Data as a dimension.
- Click and drag a field or master item under Data as a measure for the length of bars.
- Click and drag a field or master item under Data as a measure for the height of line.
- 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 may want to adjust its appearance and other settings in the properties panel.
For more information, see Changing the appearance of a visualization.