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

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

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

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

I tried putting in the =NA() into the cells the chart reads but it still
connects the lines.

"Jon Peltier" wrote:

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

NA() is not quite the same as a blank. It displays lines in a series that is
formatted with lines. If you need to show a gap, you can try the technique
on Andy Pope's web site:

http://andypope.info/charts/brokenlines.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"Abode" wrote in message
...
I tried putting in the =NA() into the cells the chart reads but it still
connects the lines.

"Jon Peltier" wrote:

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