how to combine cluster and stack in a single chart?

sophia · Nov 24, 2004

I would like to create a chart that can show both the comparison of two
categories and percentage in each category.

Debra Dalgleish · Nov 24, 2004

If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and Jon Peltier has links to other sites with information:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Possible to Combine reports to's to a single box?	0	Apr 6, 2021
Stacked Clustered Column?	1	Aug 23, 2012
Combine Sumifs with Subtotal	0	Apr 2, 2019
Move Chart with Text	0	Mar 1, 2020
Stacked Bar Chart	1	Apr 3, 2014
How to create a bubble chart with more than 2 variables.	0	Nov 2, 2021
How to sync OL365 contacts and calendar to iPhone without iTunes?	1	Apr 23, 2021
stacked and clustered charts together	2	Feb 11, 2009

Ask a Question