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

Pie Charts in Excel Pie Charts are used widely in the Microsoft Excel community but for the wrong analysis. Even though pies are delicious!, a Pie Chart should only be used to show several parts that make up a whole, for example, a product cost breakdown, margin breakdown or the market share of c...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization: Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Excel Chart Marker Options The Marker Options within an Excel chart enables you to add different marker types or shapes on your chart to distinguish a data series or its individual data points. To bring up the Marker Options you need to click on your Excel chart and make sure that all the points are sel...
Dotted Line Organizational Charts You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in Excel You can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this h...