Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stack charts on 2 axis Roy Excel Discussion (Misc queries) 1 May 16th 07 02:01 AM
Excel Chart - 2 column stack /w 1 comparison column wclairmont Charts and Charting in Excel 1 December 1st 06 01:54 AM
Multiple data in stack column chart SMueller Charts and Charting in Excel 1 June 30th 06 09:56 PM
clustered stack column charts Lou T Charts and Charting in Excel 3 October 3rd 05 11:17 PM
clustered stack column charts Lou T Charts and Charting in Excel 0 September 26th 05 06:17 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"