Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Y axis in Stack Column
I have three series of data listed below:
Year 2008 2009 2010 2011 2012 2013 S1 2,104 2,097 2,093 2,211 2,207 2,212 S2 462 325 324 332 341 349 S3 753 753 1,299 1,278 1,257 1,235 I created a stack column chart with everything else is fine but the Y-axis. The scale of Y axis listed $0,$0, $0, $0, $1, $1, $1, $1, etc with (Min:0, Max:100; Major Unit: 10; Minor Unit:2; Floor (XY plane) Crosses at: 0). After I changed the set up as Min: 0, Max: 2500, Major Unit: 500 and Minor Unit: 100, the number on Y-axis becomes showing $0, $5, $10, $15, $20, $25 with the chart is way shrinked. It seems I just could not get it right and it seems that computer only take 1/100 of what I input. Could anyone please help me with this??? I would really appreciat it!!!! Thanks, Ally |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stack charts on 2 axis | Excel Discussion (Misc queries) | |||
Excel Chart - 2 column stack /w 1 comparison column | Charts and Charting in Excel | |||
Multiple data in stack column chart | Charts and Charting in Excel | |||
clustered stack column charts | Charts and Charting in Excel | |||
clustered stack column charts | Charts and Charting in Excel |