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

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