Help Needed with a Chart

[LBR]

I have to create charts from patient's blood tests results.

The x axis would be the time.
Then there is a Normal Range low and high for that time.
And finally the patient's value.


My first column is the time
Next column is the Normal Range Low for that time period.
Next column is the Normal Range High...
Final column is the actual Patient's Value for that time.

Looks something like:

12:00, 0, 10, 45
01:00, 0, 25, 65
02:00, 10, 40, 75




Thanks!!!!

 

[etaf]

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Time[/TD]
[TD="class: xl63, width: 64"]LowRange[/TD]
[TD="class: xl63, width: 64"]HighRange[/TD]
[TD="class: xl63, width: 64"]Patient[/TD]
[/TR]
[TR]
[TD="class: xl64"]12:00[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]45[/TD]
[/TR]
[TR]
[TD="class: xl64"]01:00[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]25[/TD]
[TD="class: xl63"]65[/TD]
[/TR]
[TR]
[TD="class: xl64"]02:00[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]40[/TD]
[TD="class: xl63"]75
[/TD]
[/TR]
</tbody>[/TABLE]

does that format not plot a graph OK - new myself so had hoped to attach an example - but cant seem to

 

[Robert Mika]

I have to create charts from patient's blood tests results.

The x axis would be the time.
Then there is a Normal Range low and high for that time.
And finally the patient's value.


My first column is the time
Next column is the Normal Range Low for that time period.
Next column is the Normal Range High...
Final column is the actual Patient's Value for that time.

Looks something like:

12:00, 0, 10, 45
01:00, 0, 25, 65
02:00, 10, 40, 75




Thanks!!!!

Hello and welcome.
With some adjustments this shuld help:
AJP Excel Information - Stacked clustered chart