Column Charts - stacked and grouped

[jtd1]

I would like to chart three series. I would like two
columns in each group. The first column in a group would
be series 1. The second column in a group would be
series 2 and 3 stacked on each other. Is that possible?
I've come close by using secondary axis but the columns
are plotted over each other.

 

[Guest]

Check out Jon Peltier's site at www.peltiertech.com

I know he has something there on this, but I don't have time to look it up
right now.

 

[Jon Peltier]

Here's what Barb was looking for:

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

It provides a few links to sites with good descriptions of
clustered/stacked columns. Your first column position in the chart has
only one series in the stack, the second has two.

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