| View previous topic :: View next topic |
| Author |
Message |
zxuel
General User
Joined: 05 May 2007
Posts: 8
|
 Posted: Sat Aug 09, 2008 10:27 pm Post subject: Y Auto Scaling |
 |
|
| 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 |
|
 |
Jens S
Power User
Joined: 26 May 2008
Posts: 84
Location: Denmark
|
| Posted: Sat Aug 09, 2008 11:05 pm Post subject: |
|
|
Have you tried to dobble-click on the chart, then Format - Axis - Y-Axis
Jens |
|
| Back to top |
|
|
zxuel
General User
Joined: 05 May 2007
Posts: 8
|
| Posted: Sat Aug 09, 2008 11:46 pm Post subject: |
|
|
| 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 |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Sat Aug 09, 2008 11:54 pm Post subject: |
|
|
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 |
|
|
|
