Charts: How can I get a date axis to include hours and minutes
 

Hi

I am creating a chart monitoring (my dog's) breathing rate over time. I
cannot check the rate at the same time each day so data entries are at
different times of day.

I have the date column in my spreadsheet in the format dd/mm/yyyy hh:mm

When I go to make a simple line chart, if the horizontal axis is in date
format, it only resolve the day part of the information, and so all my data
for each day appears in the one horizontal place.

I can set the axis as text type, and I can then see each data point ok - but
it does not reflect the time element of my data.

Please can you advise me how to get around this?

many thanks

John

Answer: Charts: How can I get a date axis to include hours and minutes
 

Charts: How can I get a date axis to include hours and minutes
 

Have you tried an XY chart (with lines), instead of what Microsoft
confusingly called a line chart?
--
David Biddulph

"John McCombe" wrote in message
...
Hi

I am creating a chart monitoring (my dog's) breathing rate over time. I
cannot check the rate at the same time each day so data entries are at
different times of day.

I have the date column in my spreadsheet in the format dd/mm/yyyy hh:mm

When I go to make a simple line chart, if the horizontal axis is in date
format, it only resolve the day part of the information, and so all my
data
for each day appears in the one horizontal place.

I can set the axis as text type, and I can then see each data point ok -
but
it does not reflect the time element of my data.

Please can you advise me how to get around this?

many thanks

John

Charts: How can I get a date axis to include hours and minutes
 

Thanks David

that's it

You're right, I was confused and thought that a line chart was an XY chart -
but know better now!

Thanks for your quick and accurate response - great help

John

"David Biddulph" wrote:

Have you tried an XY chart (with lines), instead of what Microsoft
confusingly called a line chart?
--
David Biddulph

"John McCombe" wrote in message
...
Hi

I am creating a chart monitoring (my dog's) breathing rate over time. I
cannot check the rate at the same time each day so data entries are at
different times of day.

I have the date column in my spreadsheet in the format dd/mm/yyyy hh:mm

When I go to make a simple line chart, if the horizontal axis is in date
format, it only resolve the day part of the information, and so all my
data
for each day appears in the one horizontal place.

I can set the axis as text type, and I can then see each data point ok -
but
it does not reflect the time element of my data.

Please can you advise me how to get around this?

many thanks

John