Y Axis Scale Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Log scale. Like Logrithmic Scale. I tried to do that but It gave me an
error. In between days I have a blank entry with no values for the X and Y
to display there is a new day and also insure that the scale doesn't show
around an 800 minute gap inbetween entries. I think since either that or the
fact that I have the first entries of the day start a 0(Y) minutes making the
Y axis logrithmic wont work. The First entry of the day starting at 0 is an
easy fix since I can have the program automatically set it to .5 minutes or
something like that. But what about the blank entries for a new day?!.
 
Easy - don't skip blank rows. And since the first one isn't coming "after"
another, don't even list it. One way to hide these points without
rearranging the data range is to insert this formula

=NA()

into a cell that would otherwise show zero or a blank. The point doesn't
appear, and Excel doesn't keep reminding you about zeros and logs and all
that. This leaves an ugly #N/A error in the cell, but you can use
conditional formatting to hide the error.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
I tried putting in the =NA() into the cells the chart reads but it still
connects the lines.
 
Back
Top