Blood Pressure User Defined Chart for Isolated Systolic Hypertensi

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
donaldb@281.com
"VJH" <VJH@discussions.microsoft.com> wrote in message
news:DF9E6CC5-D805-4FD0-B9AA-B8A5FEFC8B5D@microsoft.com...
> 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 <DF9E6CC5-D805-4FD0-B9AA-B8A5FEFC8B5D@microsoft.com>,
VJH@discussions.microsoft.com 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
>