Download Excel Workbook
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.
download workbookColumn-12-Month-Trend.xlsx
Helpful Resource:
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.
