Column Charts - stacked and grouped
 

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.

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.

"jtd1" wrote:

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.

Here's what Barb was looking for:

http://peltiertech.com/Excel/ChartsH...sterStack.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/
_______

Barb R. wrote:

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.

"jtd1" wrote:


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.