example
A1="Month"
B1= ""
C1= "Rep1/3"
D1= "Rep2/4"
A2="Jan"
B2="North"
C2=rep1 value (Jan)
D2=Rep2 value (Jan)
A3="Jan"
B3="South"
C3=Rep3 value (Jan)
D3=Rep4 value (Jan)
A5="Feb"
B5="North"
C5=rep1 value (Feb)
D5=Rep2 value (Feb)
A6="Jan"
B6="South"
C6=Rep3 value (Feb)
D3=Rep4 value (Feb)
etc.
This is four columns rather than 3 like I said before, but I added the
north and south designators.
Plot columns C and D as stacked chart and set the Width of the columns as
one hundred %
go to chart_source data_ series and in Catagorie X axis lables enter A2:B37
(or however low you need to go


"Amanda" wrote:

Hi,

This doesn't allow me to show the four reps data? It stacks north and south
twice, or have I misunderstood?

Amanda

"bj" wrote:

Set up your data such that there are three rows (or columns) per month
have one row be your north, one be south and one be blank.
make a stacked column graph and set the width of the columns to 100 percent.


"Amanda" wrote:

Hi,

I have four pieces of data which I wish to stack in two columns, I can only
manage to create a graph with one colum containing all four pieces of data.

For example:
North
Rep1 - jan05 - feb05 - mar05 - etc
Rep2 - jan05 - feb05 - mar05 - etc

South
Rep3 - jan05 - feb05 - mar05 - etc
Rep4 - jan05 - feb05 - mar05 - etc

By month, I would like to see two columns, one containing north and one
containing south. (North is a stack of reps 1 & 2, south of reps 3 & 4).

I hope this makes sense, and someone can help me.

Thank you

Amanda