Peltier Technical Services, Inc.
 

Peltier Technical Services, Inc.
- Custom Excel Solutions

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel
- Site Index and Search - RSS

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart
  Box and Whisker
 

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

  

Creating a Clustered-Stacked Column Chart.

Excel offers clustered column charts and stacked column charts among its standard options. How do you combine a stacked column chart with a clustered column chart?

Through careful arrangement of the data in your worksheet, you can make a stacked column chart that looks like a clustered-stacked column chart. This can also be done to make clustered-stacked horizontal bar charts. The following entry in the PTS Blog shows how it is done with illustrated step-by-step instructions:

Clustered-Stacked Column Charts
 

These web sites show similar techniques for creating clustered-stacked column charts:

There is a tutorial showing this technique on Bernard Liengme's site:
  www.stfx.ca/people/bliengme/ExcelTips/Columns.htm.

Bernard's tutorial is based on the example on Stephen Bullen's web site:
  oaltd.co.uk/Excel/SBXLPage.asp#Charting, download FunChrt4.xls.

Andy Pope shows a similar approach here:
  andypope.info/charts/stackside.htm

The following MSKB article also has an example:
  XL2000: Creating Charts with Multiple Groups of Stacked Bars.

 

 

Create Excel dashboards quickly with Plug-N-Play reports.

Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile