|
|
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. This can also be done to make clustered-stacked horizontal bar charts. In Clustered-Stacked Column Charts I show how it is done with illustrated step-by-step instructions. PTS Clustered-Stacked Column Chart UtilityThe protocol required to create clustered-stacked charts is rather tedious, and the data layout is complicated, so I have written a 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.
To purchase the Professional Cluster Stack Chart Utility, visit 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.Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2009. All rights reserved. |
