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
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
User Defined Queries | tvt | Running & Setting Up Queries | 2 | December 21st, 2004 11:55 PM |
User defined paper size for a report | David Wren | General Discussion | 0 | November 9th, 2004 02:25 PM |
Query with multiple user defined parameters | Leo | Running & Setting Up Queries | 1 | August 12th, 2004 09:51 AM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |
Excel 97 User Defined Charts & Text Boxes | Ella Davis-Suggs | Charts and Charting | 1 | September 16th, 2003 12:01 PM |