Double column with 2 different axis

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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 (se
attached), but I don't think you can stack series plotted on differen
y axes.

One of her cleverer posters may be able to combine a side-by-sid
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=46076
 
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
 
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)
 
The discrepancy made by the diferences of 2 stack up data
under the same date is fine with me.
Click to expand...
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
 
To pose a question, what would the height of column B be? Would it b
100+12 =112 or would it just touch 100. Perhaps you just mean th
latter coz otherwise your secondary axis cannot end at 180.

Nevertheless, drawing on Nicky's solution, I have put together th
attached chart, which you can modify depending on the answer to th
previous question.

The principle is as follows:
1. Use two dummy series A1 and C1 (containing formulae) which just ar
just as tall as A and C, but in the secondary axis. They act a
appropriate heights for series B and D.
2. Now plot A and C on the primary axis and A1,B,C1 and D on th
secondary axis.
3. Choose stacked column for all.
4. Now make series A1 and C1 transparent by setting their border an
patterns to none.

- Leni

Attachment filename: temp.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46277
 
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
 
Back
Top