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

Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
Create a Treemap Chart With Excel 2016   Treemap Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month. The tree branches are represented by rectangles, wherein each rectangle's siz...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own. A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc. We are going ...