New chart type proposed (unless it exists) to show blood pressure with
highlighted difference for ISH (see e.g.
http://www.medicinenet.com/high_bloo...sure/page3.htm) or
http://www.nhlbi.nih.gov/hbp/hbp/whathbp.htm
3 series values: (1) systolic, (2) diastolic, and (3) pulse pressure (=
systolic minus diastolic)
For series 1 and 2, use current line graph
Series 3, difference would be highlighted by a vertical line (with label)
connecting Series 1 and 2 plot points for each reading

This type of chart might have other uses (generalize BP terminology S, D, PP
to high, low, difference).


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

I have one I created sometime ago that I will send ONLY if you ask me OFF
list.
I will NOT respond to requests made here.

--
Don Guillett
SalesAid Software

"VJH" wrote in message
...
New chart type proposed (unless it exists) to show blood pressure with
highlighted difference for ISH (see e.g.
http://www.medicinenet.com/high_bloo...sure/page3.htm) or
http://www.nhlbi.nih.gov/hbp/hbp/whathbp.htm
3 series values: (1) systolic, (2) diastolic, and (3) pulse pressure (=
systolic minus diastolic)
For series 1 and 2, use current line graph
Series 3, difference would be highlighted by a vertical line (with label)
connecting Series 1 and 2 plot points for each reading

This type of chart might have other uses (generalize BP terminology S, D,
PP
to high, low, difference).


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...excel.charting

Create a line chart. Double-click either series. From the Options tab
select 'High-low lines'

Moving beyond your immediate request...

You can also create a kind of 'conditional chart.' Suppose your
systolic/diastolic data are in B:C starting with B2. Then, in E2 enter
=IF(AND(B2=140,C2<=90),C2,NA()) In F2 enter =IF(ISNA(E2),C2,NA())
Copy E2:F2 as far down as you have data in B:C. Plot B and E. Set the
style to no-line and only marker. Add the High-low lines as above.
Double click the series corresponding to E. From the Patterns tab set
the marker color to Red. Double-click any of the high-low lines. Set
the color to red.

Add F. Move F to the secondary axis (double-click the plotted series
then from the Axes tab select secondary). If necessary, set the High-
low lines to 'None.' Format the markers to Green.
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
New chart type proposed (unless it exists) to show blood pressure with
highlighted difference for ISH (see e.g.
http://www.medicinenet.com/high_bloo...sure/page3.htm) or
http://www.nhlbi.nih.gov/hbp/hbp/whathbp.htm
3 series values: (1) systolic, (2) diastolic, and (3) pulse pressure (=
systolic minus diastolic)
For series 1 and 2, use current line graph
Series 3, difference would be highlighted by a vertical line (with label)
connecting Series 1 and 2 plot points for each reading

This type of chart might have other uses (generalize BP terminology S, D, PP
to high, low, difference).


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting