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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin