Dianne -

Construct an XY chart, not a Line chart. You can use a style that connects the
points with lines.

To set your scales, double click the axis. Although Excel expects a regular decimal
value, you can enter date-time values for min, max, and spacing. For example, enter

7/14/05 23:45 for minimum,

7/15/05 01:15 for maximum, and

0:05 for major spacing.

When you access this dialog again, Excel will have converted your entries to
decimals, but you can overwrite them with the more readily understood data-times.

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


Dianne wrote:

I have stats where I would like to have 5-10 minute intervals for my x axis.
The Y axis has simple numbers. For example:

Date/hour/minutes Y
7/14/05 23:45 45
7/14/05 23:50 50
7/15/05 01:00 40

It is only producing a chart with all the different incremental values
spread in equal proportions - I want the numbers to appear closer to each
other (the first two are only 5 minutes apart - the last two are 15 minutes
apart) as they should - otherwise the chart is off and spread way out rather
than looking a a correct time frame.

I have tried with day timelines but it will not divide the days for me only
- I have also tried to use the general number rather than the time/hour
number as the min and maximum values.

Please help, it is driving me crazy.