|
|
Peltier Tech
Books at Amazon.com
Buy me a coffee If this topic or the whole site has been helpful, please support further development by treating me to a cup of coffee. |
Clustered-Stacked Column Charts.
Creating a Clustered-Stacked Column ChartExcel 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 UtilityIn 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 WebThese web sites show similar techniques for creating clustered-stacked column charts:
|
Peltier Technical Services, Inc.Commercial Utilities | Custom Solutions | Training | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2010. All rights reserved. |
