A
Ally
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
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