Clustered Column Chart: 12 Month Trend

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

Founder & Chief Inspirational Officer

at

MyExcelOnline.com

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.

See also  How to Create Overlay Charts in Excel