Clustered-Stacked Column Charts.

Peltier Tech Cluster Stack Chart Utility The tutorials in the links below show how to create Clustered-Stacked Charts, including the specialized data layout needed, and the detailed combination of chart series and chart types required. This manual process takes time, can be prone to error, and becomes tedious.

I have created the Peltier Tech Cluster Stack Chart Utility to create such charts automatically from raw data. This utility, a standard Excel add-in, lays out data in the required layout, then constructs a chart with the right combination of chart types. This is a commercial product, tested on hundreds of machines in a wide variety of configurations, which saves time and aggravation.

The Peltier Tech Cluster Stack Utility creates charts in either horizontal or vertical orientation.

Please visit the Peltier Tech Cluster Stack Chart Utility page or the Peltier Tech Cluster Stack Chart Utility Documentation page for more information.

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. In Clustered-Stacked Column Charts. I show how it is done with illustrated step-by-step instructions. This technique can also be applied to Clustered-Stacked Horizontal Bar Charts.

PTS Cluster Stack Chart Utility

In this page I have described a technique for constructing clustered and stacked column charts in Excel. The protocol required to create clustered-stacked charts is rather tedious, and the data layout is complicated, so I have developed the PTS Cluster Stack Chart Utility that allows the user to construct clustered-stacked column charts directly from the data. The utility inserts a new worksheet, adds a table with the appropriate data arrangement, and then creates and formats a clustered-stacked column chart from this table.

The utility allows the user to set up a simpler data range, and through a dialog select the clustering and stacking configuration.

The utility is designed to work in Excel for Windows versions 2000, 2002, and 2003, and 2007. The utility has not been tested in any Macintosh version or in Excel 97; it is not expected to work in these versions.

Read about the PTS Cluster Stack Chart Utility.

Clustered-Stacked Column Charts Elsewhere on the Web

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.

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2010. 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

My MVP Profile