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 WORKBOOK

Column - 12 Month Trend

Helpful Resource:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature.There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle.Here is how you insert a Radial Cy...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization:Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts:#1 - COPYING A CHARTClick on the chart with your left mouse key and at the same time hold down the CTRL key to copy it and move the chart to wherever you want.When you are done, let go of the ...
Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data.The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...