Combo Charts and Secondary Axes
メニューを表示するにはスワイプしてください
Combo charts combine two chart types in one visualization. They are used when two data series have different scales but need to be shown together. A common example is: revenue (large numbers) and conversion rate (percentage).
If both are plotted on the same axis, one series becomes unreadable. A secondary axis solves this.
Creating a Combo Chart
- Select the dataset with multiple numeric series;
- Go to Insert;
- Choose Combo Chart;
- Assign different chart types to each data series;
- Enable Secondary Axis for the series with a different scale.
Excel will display one axis on the left and another on the right.
When to Use a Secondary Axis
Use a secondary axis when: | Avoid using secondary axes when: |
|---|---|
Data series have significantly different value ranges. | Scales are similar. |
One series becomes compressed or unreadable. | It creates confusion. |
You need to compare trends, not absolute values. | The relationship becomes misleading. |
Using the provided dataset:
- Insert a Combo Chart;
- Set one series as a Column Chart;
- Set the second series as a Line Chart;
- Enable a Secondary Axis for the line series.
Goal: display both series clearly despite different value scales.
フィードバックありがとうございます！
AIに質問する
AIに質問する
何でも質問するか、提案された質問の1つを試してチャットを始めてください
