If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you.

In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014.

DOWNLOAD WORKBOOK

 

STEP 1: Select the table on where we want to create the chart on.  

clustered-01

 

STEP 2: Go to Insert > Bar Chart > Clustered Bar.

clustered-02

Your Clustered Bar Chart is now ready:

clustered-03

 

 

Clustered Bar - Year Over Year

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

Clustered Bar Chart: Year to Date Sales If you want to compare your Year to Date sales and have category names (eg. products, business names, channel partners, sales reps etc)  which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I a...
Win/Loss Sparklines When you have  a large data set with positive and negative numbers, a great way to visualize the trend is to add a Win/Loss Sparkline next to your data.That way you or the reader can easily spot the trends and patterns.To enter a Win/Loss Sparkline in Excel you firstly ne...
XY Scatter Chart: Related Variables When you want to find out whether or not 2 variables are related or correlated, then an XY Scatter Chart should be used to plot the graph.Related variables will show up on the graph as dots that are almost in a straight line.  Examples of variables that have relationships cou...
Overlap Graphs in Excel Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results.This overlay of graphs may seem like a difficult exercise but it is a very easy process.First you need to edit your "Plan" graph by clicking on its series and pres...