View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Y Axis Scale Problem

Sounds like a job for a log scale.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Abode" wrote in message
...
Hello. I'm making a chart that shows me the times between entries in
another
worksheet. Thusfar everything works find but I noticed that there is the
occational drought of entries and the time goes from averaging around
fifteen
minutes to a couple of hours. Especially during lunch. Is there a way I
can
get the Y axis to increase the Major unit the higher in the scale a point
is.
Something where I can have on hour take up half the total Y axis and the
second hour take up another half or third and so on so I can put a nine
hour
workday on the scale and still have everything look somewhat normal. If
any
of you have any ideas how I could do this it would be greatly appreciated.
Thank you