Excel 2007 : Cluster-Stacked Column Chart Excel 2007

**starbecks** · 03-05-2010, 09:12 PM

I'm trying to make a cluster stacked column chart. And I've found the site: http://peltiertech.com/WordPress/clu...column-charts/

However, I'm still having trouble doing what I want to do.

I've attached the workbook. Sheet 1 is the original data with a stacked column chart for grade. I would like to add gender and race, as well. I tried to reconfigure the data in Sheet 2 per the website above. Now I'm kind of stuck.

Any help would be great

**Andy Pope** · 03-06-2010, 11:16 AM

You need to include some blank rows to split out the data.
You can replace the numbers on the inner category labels with a space.

**starbecks** · 03-08-2010, 03:08 PM

Thanks so much. This is greatly helpful!

**mpz** · 06-13-2012, 02:50 PM

Hello, I am really new to this stacked column chart. What do I do in order to separate the stacked column from the other bars?

**arlu1201** · 06-13-2012, 02:57 PM

Mpz,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.