Double column with 2 different axis

I have a problem on creating a stack up chart :
__A__ __B__ __C__ __D__
01/02/04 12 100 32 150
02/02/04 32 120 56 170

On the X axis is the Date. A and B is belong to 1 group,
therfore i need them to stack up wherelse C and D form
another one.These 2 stack up bar group are under x
axis "01/02/04"

This not only need to built a double column chart but also
with 2 Y axis (A and C) (B and D)

No 1 Y axis is between 10-60
No 2 Y axis is between 90-180


Thanks~!

Hi Eric

you can show two or more sets of stacked columns side by side (see
attached), but I don't think you can stack series plotted on different
y axes.

One of her cleverer posters may be able to combine a side-by-side
stacked column with a trick to spit the y axis, though.

Attachment filename: multiple stack2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=460764
---
Message posted from http://www.ExcelForum.com/

Taking Nicky's point a bit further, what does it mean to have a stacked
column where the bottom item is on one axis and the other is on another
axis? If the axis scales are different, how would you expect the
visual effect of stacking two items to look?

Take the C and D values for 1/2/04. Using your definition of axis
scales, C should be about 40% of the height of the plot area (20/50).
D should be 2/3 of the height (60/90). How would you reconcile the
discrepancy?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a problem on creating a stack up chart :
__A__ __B__ __C__ __D__
01/02/04 12 100 32 150
02/02/04 32 120 56 170

On the X axis is the Date. A and B is belong to 1 group,
therfore i need them to stack up wherelse C and D form
another one.These 2 stack up bar group are under x
axis "01/02/04"

This not only need to built a double column chart but also
with 2 Y axis (A and C) (B and D)

No 1 Y axis is between 10-60
No 2 Y axis is between 90-180


Thanks~!

The discrepancy made by the diferences of 2 stack up data
under the same date is fine with me.

but the problem comes when i want A using 1st Y axis and
B refer to 2nd Y axis though their are under same date
(stack up)

-----Original Message-----
Taking Nicky's point a bit further, what does it mean to
have a stacked
column where the bottom item is on one axis and the other
is on another
axis? If the axis scales are different, how would you
expect the
visual effect of stacking two items to look?

Take the C and D values for 1/2/04. Using your
definition of axis
scales, C should be about 40% of the height of the plot
area (20/50).
D should be 2/3 of the height (60/90). How would you
reconcile the
discrepancy?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
The discrepancy made by the diferences of 2 stack up data
under the same date is fine with me.

I'm sure your problem makes sense to you, but I have no clue what it
means to have a stacked column with individual blocks scaled
differently. To me it is logically and visually incomprehensible.
Hopefully, someone else will be able to help you out.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
The discrepancy made by the diferences of 2 stack up data
under the same date is fine with me.

but the problem comes when i want A using 1st Y axis and
B refer to 2nd Y axis though their are under same date
(stack up)

-----Original Message-----
Taking Nicky's point a bit further, what does it mean to
have a stacked
column where the bottom item is on one axis and the other
is on another
axis? If the axis scales are different, how would you
expect the
visual effect of stacking two items to look?

Take the C and D values for 1/2/04. Using your
definition of axis
scales, C should be about 40% of the height of the plot
area (20/50).
D should be 2/3 of the height (60/90). How would you
reconcile the
discrepancy?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Thanks for your advise but none the less the group 1 and 2
should be a stack up (side by side) and is same goes to 3
and 4.

With 1 and 3 refer to 1 axis , 2,4 refer to 2nd axis

1=30
2=200
3=10
4=500

The end result for 1 axis will be from 0-50, 2 axis from
100-1000
The 2 bar (1,3) (2,4) will not interfere with each other
because they are refer to different axis.


They can co-exist as i have done the bar and accumulative
line. the difference now is from the line to bar type

Thanks