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

Area Chart: Highlight Chart Sections When you are showing 12 month sales results using a Line Chart and want to highlight certain values within the chart to make them stand out (like Q2 & Q3 results), then an Area Chart will be needed.To do this there are a few steps to follow:1. Enter the Line Chart for...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt.To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set.If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...
Adding Data Labels To An Excel Chart Data Labels make an Excel chart easier to understand because they show details about a data series or its individual data points.Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point.In ou...