View Single Post
  #2  
Old February 12th, 2007, 07:35 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Time-scale chart measured in hours & minutes

Combine time and date into a single column, and don't leave out any dates.
Plot as an XY chart. Format the X axis using a date-time format.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John" wrote in message
...
I am hoping to get a time-scale chart using hours & minutes, as well as
days.
I know the generic help response is that it can't be done, but it doesn't
seem possible that this need hasn't been addressed. What is the
workaround?
Here is an example of my data set:

Date Time High Blood Pressure Low Blood Pressure
2/5/2007 12:00 AM 182 117
2:00 PM 143 90
6:00 PM 177 112
8:00 PM 166 101
2/6/2007 7:00 AM 159 94
2:30 PM 165 103
2:35 PM 155 94
6:00 PM 177 102
7:00 PM 148 97
10:00 PM 150 86
10:30 PM 121 70
12:20 AM 138 86