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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Overlap Graphs in Excel Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results.This overlay of graphs may seem like a difficult exercise but it is a very easy process.First you need to edit your "Plan" graph by clicking on its series and pres...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...
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...
Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data.The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...