If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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~! |
#2
|
|||
|
|||
Double column with 2 different axis
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/ |
#3
|
|||
|
|||
Double column with 2 different axis
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~! |
#4
|
|||
|
|||
Double column with 2 different axis
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 |
#6
|
|||
|
|||
Double column with 2 different axis
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 |
Thread Tools | |
Display Modes | |
|
|