|
Books that I own and use while developing in Excel |
|
Excel or charting related products and services which I use or feel are worthwhile additions |
|
2008 US East Coast Excel User Conference |
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 bar charts. The following links show how it is done:
|
There is a tutorial showing this technique on Bernard Liengme's site: Bernard's tutorial is based on the example on Stephen Bullen's web site: Andy Pope shows a similar approach here: The following MSKB article also has an example: |