An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.
To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.
Below I show how easy it is to create such a chart.

Helpful Resource: