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/
_______

"Abode" wrote in message
...
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?!.

"Jon Peltier" wrote:

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