Excel 2016 has made this much easier, if you are working with Excel 2016, please refer here for details.

In the Insert Tab from the Ribbon, click Column, then select Clustered Column.

The percentage columns are very short and we need to change them to a line chart.

Right click on the line chart, then select Format Data Series to make a secondary Y-Axis for the line chart ().

You can change the color, Axis value or any other elements to make it better.

Name This field is for validation purposes and should be left unchanged.

Learn more For Customers Industry INDUSTRIES Education Government Healthcare Retail SOLUTIONS Classroom and Labs Business Centers Field Computers Store Computers Conference Computer Management Healthcare Computer Management Solution Managed Services Solution Reboot to Restore Education Uninterrupted Reduce the Cost of Providing Education to Student While Guaranteeing Zero Disruption Downloads Purchase Library By Products Deep Freeze Deep Freeze Cloud Deep Freeze MDM Chromebook MDM Anti-Virus Anti-Executable WINSelect Insight Power Save Data Igloo Faronics Core Campus Affairs By Resources Case Study Feature History Get Started Guide Product Brochures Product Specs Release Notes Software Downloads Technical Papers User Guide Videos Webinar White Papers Search product brochures, guides, case studies and technical documents.

Select Product Select Resource Select Product Deep Freeze Deep Freeze Cloud Deep Freeze MDM Chromebook MDM Anti-Virus Anti-Executable WINSelect Insight Power Save Data Igloo Faronics Core Campus Affairs All Resources Case Study Feature History Getting Started Guide Product Brochures Datasheets Release Notes Software Download Technical Papers User Guide Videos Webinar White Papers Company About About Us Customer Speak Affiliations Careers UPDATES News Press Release Blog Legal Support Professional Services Faronics Labs Partner Portal Contact Us Faronics Insight 8.0 is 8X faster 5 Things You Need to Know About Proteus Malware Faronics Announces Anti-Executable Security Suite, Offers Layered Security Threat Protection Platform 4 Tips for Effective Business Continuity and Disaster Recovery (BCDR) Planning See all posts Clustered and stacked bar charts in excel.

Possible Posted By Dmitry Shesterin 08-21-2012 If you have ever tried to build a chart like this in excel, you are out of luck.

With excel you can have either clustered column bar charts, or stacked column bar charts, but not both.

Combo Chart In Excel Series Show On

If you are a super advanced excel guru, you can get another set of series show on a secondary axis, but thats pretty much it.

It looks ugly and confuses the hell out of anybody looking at such a chart.

Bill Jelen from MrExcel attempted to address this limitation in his podcast.

Kudos to Bill for making the Impossible probable, but the workaround is arduous, the resulting data table is out of whack and the legend is confusing as hell.

I think it is a good workaround overall given you cant build a clustered stacked chart in excel.

This called for an outside the box solution:) In order to get a clustered and stacked bar chart, one could create two stacked column charts referring to their respective datasets and then just superimpose them on top of each other.

Combo Chart In Excel How To Get A

Heres how to get a stacked and clustered column bar chart done in excel (tested on Excel 2011 for Mac): Create your first stacked bar chart.

Specify major and minor axis ticks, so they are consistent between the charts you are going to merge later.

You can have as many clusters as you wish, we will work with just two for clarity).

Adjust series colors, order, fonts, and anything else you might want see in your chart to make it perfect.

By now you have a perfect stacked column bar chart that is missing your desired second (or third ) cluster column.

Paste your chart and adjust the corresponding datasets to refer to the other cluster of data.

In your second chart, remove lines and fill from plot area, axes and legend.

By now you should see bars from your first chart beaming through your second chart.

You are done Good luck and get yourself a preview of the 2013 excel, it is awesome About The Author Dmitry Shesterin Dmitry has done everything.

From sales and marketing in mobile telecommunications and printing (in Russia and Germany) to sales engineer and marketing lead (at Faronics).

Dmitry has an unrivaled love of Excel and his sense of humor resembles Ambrose Bierce, his favorite writer.

Categories All Blogs Blog Cloud Cloud Product Update Computers Education Featured Green Tech Healthcare Malware Alert Partner Spotlight Privacy Product Update Security Social Media Tech Trends Technology Trends Sign Up For A 30-Day Trial Deep Freeze Enterprise Centralized deployment and management as well as a host of configuration options for the Enterprise.

Free Trial Learn More Organization Name First Last Phone Work Email StateProvince StateProvince.

States Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Provinces Alberta British Columbia Manitoba New Brunswick Newfoundland Labrador Northwest Territories Nova Scotia Nunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon Yes, I would like to receive updates from Faronics.

Combo Chart In Excel For Mac