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 am comparing their Year to Date sales.

DOWNLOAD WORKBOOK

Clustered Bar - YTD Sales

Helpful Resource:

project-management-bundle-excel-ad-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

Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
Create a Pareto Chart With Excel 2016   Pareto Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are the most common. A Pareto chart, also called a sorted histogram, is a column...
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...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set. If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...