How do I make a stacked column chart with side-by-side comparison.
 

Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?

Take a look at Jon Peltier's site. He has lots of examples of different
chart types.

I'll start you out on the page you might want to look at.

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"Tim" wrote:

Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?

Here's a page with links to clustered-stacked charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Barb R. wrote:

Take a look at Jon Peltier's site. He has lots of examples of different
chart types.

I'll start you out on the page you might want to look at.

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"Tim" wrote:


Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?

Thank you both for your replies. Right after I posted, I did some more
searching and found some of Jon's earlier messages. With so many people
wanting this, you'd think it would be easier to do...

Anyway, I really WOW'ed my boss with this. She's pretty much an Excel guru
and had never seen this done before.

Thanks!

Tim

"Jon Peltier" wrote:

Here's a page with links to clustered-stacked charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Barb R. wrote:

Take a look at Jon Peltier's site. He has lots of examples of different
chart types.

I'll start you out on the page you might want to look at.

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"Tim" wrote:


Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?