Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|