OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Y Auto Scaling

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
zxuel
General User
General User


Joined: 05 May 2007
Posts: 8

PostPosted: Sat Aug 09, 2008 10:27 pm    Post subject: Y Auto Scaling Reply with quote

I am having problems with Y axis auto scaling. It is able to get the max correctly, but the min always starts from 0, even when my y-values are in the range of 1000-2000. Any work around for this problem? Thanks in advance.
Back to top
View user's profile Send private message
Jens S
Power User
Power User


Joined: 26 May 2008
Posts: 87
Location: Denmark

PostPosted: Sat Aug 09, 2008 11:05 pm    Post subject: Reply with quote

Have you tried to dobble-click on the chart, then Format - Axis - Y-Axis


Jens
Back to top
View user's profile Send private message
zxuel
General User
General User


Joined: 05 May 2007
Posts: 8

PostPosted: Sat Aug 09, 2008 11:46 pm    Post subject: Reply with quote

I did and I checked everything automatic. The max works, but the min just stuck at zero all the time no matter what y-values I have in the chart.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Sat Aug 09, 2008 11:54 pm    Post subject: Reply with quote

Maybe there is a value in your data that is approx. zero, or maybe is text rather than a number. If there's lots of data, it would be easy to miss it.

Try doing

=MAX(range with y values)

somewhere, to check.

That was the cause of a similar problem I had a couple of days ago.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group