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

Share on Google+

Google+

Related Posts

Create a Waterfall Chart With Excel 2016 Waterfall Charts are one of the many new Charts available only in Excel 2016. They are very popular in the current corporate environment as they graphically show the positive and negative movements within your Monthly Net Profit or Cash Flow. When I was working at General E...
Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart. For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables. Well you c...
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...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can! To create an Excel Table you need to highlight your data and press CTRL+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and us...