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 |
All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com