Timeline Chart Problem

[Katoomba Blue]

Hi All

Could anyone help me with a charting problem.

I need to produce a chart showing temperatures and the date and time that this temperature was recorded.

The problem is the dates and times. The temperature is recorded every minute. 05 May 2009 09:24:00:000 is the (general) format.

How do I use this date/time format to produce the y axis with one date label showing for each day, and each day split into 24 hour intervals.

Many thanks

Hope someone can help or point me in the right direction.


Diane

[Andy Pope]

can you post example workbook of your data.

what information should be on each axis?

[Katoomba Blue]

Pen Name Pen 2 Pen 2 Pen 1 Pen 1
Date and Time Max Min Max Min
05 May 2009 09:24:00:000 30.1 28 30.7 27.7
05 May 2009 09:25:00:000 33.2 30.6 34.6 31.3
05 May 2009 09:26:00:000 36.6 33.8 38.8 35.3
05 May 2009 09:27:00:000 40.3 37.2 42.9 39.6


On the x asis I want to show the temperture.
On the y axis I want to show the date and time (each day showing 24 hour intervals).

Many thanks

[Katoomba Blue]

Pen Name Pen 2 Pen 2 Pen 1 Pen 1
Date and Time Max Min Max Min
05 May 2009 09:24:00:000 30.1 28 30.7 27.7
05 May 2009 09:25:00:000 33.2 30.6 34.6 31.3
05 May 2009 09:26:00:000 36.6 33.8 38.8 35.3
05 May 2009 09:27:00:000 40.3 37.2 42.9 39.6

Sorry this looks a little better

[Andy Pope]

a workbook would look better

[Katoomba Blue]

I am not having much luck in displaying the information!!

Column 1
05 May 2009 09:24:00:000
05 May 2009 09:25:00:000
05 May 2009 09:27:00:000

Coumn 2, 3, 4, 5
All contain temperatures

[Andy Pope]

which is why, for the 3rd time, I suggest posting a workbook

[Katoomba Blue]

This is just a part of the data. The process could go on for days.

Once again many thanks

[Andy Pope]

You need to use an xy-scatter chart.

You will need to add the series using the Source data dialog as you x/y values are the reverse of what the chart would normally expect. Which is 1st column of shared X values remain columns unique Y values.

[Katoomba Blue]

Thanks very much Andy for your help.

It works a dream.


Regards




Diane