View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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