how to insert combo chart in excel for mac

Insert Combo Chart In Excel Series Show On

Comments 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.

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.

Insert 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.

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.

Now you have your second cluster, whats left is to make it transparent and align with the first one.

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.

How To Insert Combo Chart In Excel For Mac