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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts: #1 - COPYING A CHART Click 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. ...
Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar! The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholde...
Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this example I show you how easy it is to insert a His...