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

Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend.An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...
Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.Below I sho...
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 ...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story.You can adjust the WIDTH of the line to make it as thin or thick as you like.You can make your line chart have a COMPOUND or DASH effect.You can also add...