$1\mathrm{.}00$ Point: XL Step $3\mathrm{.}1\mathrm{.}4$: Create a Combo Chart

On the Attendance Data worksheet, select the ranges A$4$:A$11$ and F$4$:G$11$ and use the Insert tab to create a Clustered Column Combo chart with a Line on the Secondary Axis.

Move the chart to a sheet named $2022$ Combo chart: