Task 1 of 6
Build a combo chart from A1:C7: revenue as columns, orders as a line.
Lesson theory
Four more chart types that reports need most often:
- Combo: the first series as columns, the others as a line on a secondary axis on the right: revenue in dollars and orders in units;
- Scatter: the first column of the range is the X axis (numbers), the second is Y. You can see whether there is a relationship.
CORRELmeasures how strong it is: near 1 is a strong positive link, near 0 means no link; - Stacked column: the parts are stacked on top of each other, and the height of the column is their sum;
- Doughnut: a pie chart with a hole, and the total can be shown in the center.
Select the range together with its headers, click Chart and choose the type.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.