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.

Want to know how to create a Clustered Bar Chart with Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

 

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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin