Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Charts: How can I get a date axis to include hours and minutes


__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
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



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding hours/minutes to Date/Times RFrechette Excel Worksheet Functions 2 November 29th 06 03:53 PM
Hours and minutes display as date in formula box Dave Excel Discussion (Misc queries) 13 July 28th 06 07:47 PM
countdown days,hours,minutes,seconds to a specific date jje2149 Excel Discussion (Misc queries) 1 June 1st 06 01:47 PM
add hours & minutes to other hours & minutes to receive total hou. Wes Excel Worksheet Functions 2 March 2nd 05 12:33 AM
add column of minutes, show total in hours & minutes glider pilot Excel Worksheet Functions 1 December 30th 04 11:27 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"