If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Time-scale chart measured in hours & minutes
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Time-scale chart measured in hours & minutes
Doing this shows every reading for the day in one column, regardless of time.
I'd really like to have it spaced out accurately based on time as well. Could I be doing something wrong? "Jon Peltier" wrote: 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 |
#4
|
|||
|
|||
Time-scale chart measured in hours & minutes
You missed my second sentence:
Plot as an XY chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John" wrote in message ... Doing this shows every reading for the day in one column, regardless of time. I'd really like to have it spaced out accurately based on time as well. Could I be doing something wrong? "Jon Peltier" wrote: 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 |
#5
|
|||
|
|||
Time-scale chart measured in hours & minutes
What do you mean XY chart? Currently it's in a line chart....
"Jon Peltier" wrote: You missed my second sentence: Plot as an XY chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John" wrote in message ... Doing this shows every reading for the day in one column, regardless of time. I'd really like to have it spaced out accurately based on time as well. Could I be doing something wrong? "Jon Peltier" wrote: 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 |
#6
|
|||
|
|||
Time-scale chart measured in hours & minutes
When you create a chart, or when you choose Chart Type from the Chart menu,
you are presented with a set of options. One is Line chart, another is XY chart. They present the data with an identical set of formatting options; the difference is in how they treat the X axis data. An XY chart treats the X data as numerical, while a Line chart treats it as categorical. An XY chart then plots time as a fraction of a day, but since times are fractions and categories are integral in nature, the line chart plots times either as separate equally spaced categories or as a series of points on a single integer day. That's why I've twice suggested using an XY chart type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John" wrote in message ... What do you mean XY chart? Currently it's in a line chart.... "Jon Peltier" wrote: You missed my second sentence: Plot as an XY chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John" wrote in message ... Doing this shows every reading for the day in one column, regardless of time. I'd really like to have it spaced out accurately based on time as well. Could I be doing something wrong? "Jon Peltier" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|