Dates on a Y Axis

[eoinymc]

Hi,

I was wondering if anyone can help me..

I have the following table:

	06:40	06:50	07:40	08:50	10:10
Departure 1	1		1		1
Departure 2	2	2		2

<tbody>
</tbody>

And when I create a line graph with it, the Y axis shows 06:40 06:50 07:40 08:50 10:10, but I want it to go by the hour, so I want it to show
06:00 07:00 08:00 09:00 10:00 11:00

and have the values fall in between these times where they are applicable.

is this possible to do?

On the X axis, you can choose the min, max and the major unit, which in my case would be min: 06:00, max: 11:00 and majort unit would be 1:00

any ideas?

Thanks in advance,

Eoin

 

[davesweep]

Hello,

Try an XY scatter graph instead of a line graph.

 

[eoinymc]

thanks for your advice...

I tried that previously, but the y axis values then show up as 0 1 2 3 4 5 ...?

Am I doing something wrong?