A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Time-scale chart measured in hours & minutes



 
 
Thread Tools Display Modes
  #1  
Old February 12th, 2007, 07:04 PM posted to microsoft.public.excel.charting
John
external usenet poster
 
Posts: 2,649
Default 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






Ads
  #2  
Old February 12th, 2007, 08: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








  #3  
Old February 13th, 2007, 07:09 PM posted to microsoft.public.excel.charting
John
external usenet poster
 
Posts: 2,649
Default 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  
Old February 13th, 2007, 07:37 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default 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  
Old February 14th, 2007, 12:31 AM posted to microsoft.public.excel.charting
John
external usenet poster
 
Posts: 2,649
Default 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  
Old February 14th, 2007, 04:30 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default 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














  #7  
Old May 23rd, 2010, 07:15 PM posted to microsoft.public.excel.charting
jay gamel
external usenet poster
 
Posts: 2
Default xy chart on Excel for Mac 2004

Jon,

I have a similar chart for blood pressu day/time and systolic/diastolic and pulse. When I select XY chart, all options for Axis (Automatic, Category, Time-Scale) are grayed out whether either or both of the axis boxes are checked. All I get are times, and those are all 12 AM. Cell formats are date, time, number for the data. Any suggestions?

I'll be glad to send screen shots if they would help, or the actual file.

Also, the times format vertical in a line chart, but the dates will not and I cannot find any place to do that, though this may change if the scatter chart actually works.



Jon Peltier wrote:

When you create a chart, or when you choose Chart Type from the Chart menu,
14-Feb-07

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
...

Previous Posts In This Thread:

On Monday, February 12, 2007 1:04 PM
Joh wrote:

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

On Monday, February 12, 2007 2:35 PM
Jon Peltier wrote:

Combine time and date into a single column, and don't leave out any dates.
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
...

On Tuesday, February 13, 2007 1:09 PM
Joh wrote:

Doing this shows every reading for the day in one column, regardless of time.
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:

On Tuesday, February 13, 2007 1:37 PM
Jon Peltier wrote:

Time-scale chart measured in hours & minutes
You missed my second sentence:


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

On Tuesday, February 13, 2007 6:31 PM
Joh wrote:

What do you mean XY chart?
What do you mean XY chart? Currently it is in a line chart....

"Jon Peltier" wrote:

On Wednesday, February 14, 2007 10:30 AM
Jon Peltier wrote:

When you create a chart, or when you choose Chart Type from the Chart menu,
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
...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorials...rk-40-and.aspx
  #8  
Old May 23rd, 2010, 07:20 PM posted to microsoft.public.excel.charting
jay gamel
external usenet poster
 
Posts: 2
Default bp chart in excel 2004 for mac

I'm trying to make a similar chart in Excel Mac 2004. time, date, systolic, diastolic, pulse (FORMATS: time, date,number, number, number). The XY chart grays out all options (automatic,category, time-date) no matter which axis boxes are checked or unchecked. The chart only shows the time as 12 AM and no dates. Any suggestions?



Jon Peltier wrote:

When you create a chart, or when you choose Chart Type from the Chart menu,
14-Feb-07

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
...

Previous Posts In This Thread:

On Monday, February 12, 2007 1:04 PM
Joh wrote:

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

On Monday, February 12, 2007 2:35 PM
Jon Peltier wrote:

Combine time and date into a single column, and don't leave out any dates.
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
...

On Tuesday, February 13, 2007 1:09 PM
Joh wrote:

Doing this shows every reading for the day in one column, regardless of time.
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:

On Tuesday, February 13, 2007 1:37 PM
Jon Peltier wrote:

Time-scale chart measured in hours & minutes
You missed my second sentence:


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

On Tuesday, February 13, 2007 6:31 PM
Joh wrote:

What do you mean XY chart?
What do you mean XY chart? Currently it is in a line chart....

"Jon Peltier" wrote:

On Wednesday, February 14, 2007 10:30 AM
Jon Peltier wrote:

When you create a chart, or when you choose Chart Type from the Chart menu,
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
...

On Sunday, May 23, 2010 2:15 PM
jay gamel wrote:

xy chart on Excel for Mac 2004
Jon,

I have a similar chart for blood pressu day/time and systolic/diastolic and pulse. When I select XY chart, all options for Axis (Automatic, Category, Time-Scale) are grayed out whether either or both of the axis boxes are checked. All I get are times, and those are all 12 AM. Cell formats are date, time, number for the data. Any suggestions?

I'll be glad to send screen shots if they would help, or the actual file.

Also, the times format vertical in a line chart, but the dates will not and I cannot find any place to do that, though this may change if the scatter chart actually works.


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Customized Find Control for FlowDocuments
http://www.eggheadcafe.com/tutorials...ind-contr.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.