ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Y axis in Stack Column (https://www.excelbanter.com/excel-discussion-misc-queries/163506-y-axis-stack-column.html)

ally

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