clustered stacked chart

Topic

New Reply

Excel 97 SR-2: is it possible to have a clustered stacked column chart – i.e. if I want to show 2 stacked columns for each of my x-axis categories, and I want them clustered (i.e. adjacent) for visual effect?

Thanks

Jeremy

Reply | Quote

Replies

Jeremy,

I’m not sure if I understand your exact requirements, but would a standard stacked bar graph suffice. For the ‘cluster’ effect go to Format Data Series, select the Options Tab and set the Gap Widthh to zero.

Hope that gives you what you want

Andrew C

Reply | Quote

I asked this question in the old Lounge a long time ago and no one came up with a solution, but if there is one I would like to see it. I finished up getting a colleague to do the job in S+.

Reply | Quote

I’ve now managed to locate something that appears to do what I want on Stephen Bullen’s BMS website.

Jeremy

Reply | Quote

So Andrew has it corrrect then? Sounds like it by your original question.

You can contrive the appearance a multiple-cluster stacked chart, but it’s a bit convoluted. Example is attached. The first stack is plotted on the secondary y-axis. The second stack is actually the sum of the two stacks that would be plotted in a typical stacked chart, and is plotted on the primary axis to get it to appear behind the first stack. This way it appears stacked, but it’s really just two co-located sets of series on different axes.

You may have to set each y-axis to the same maximum scale. The chart could also be cleaned up a little. Legend items can be manually re-ordered or deleted, and the secondary y-axis can be deleted or formatted to be invisible (white font and line color).

This method works with only two stacks.

John Jacobson

Reply | Quote