Excel Question

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cwilmot

Thread Starter
Joined
Apr 21, 2001
Messages
676
I'm looking for an Excel guru, or at least someone smarter than me in this field. What I want to do is to chart 2 weeks of blood pressure readings, taken 4 times per day, using line graphs. The Y axis would be blood pressure readings and the X axis would be observation times. There would be 2 lines representing both the Systolic and Diastolic readings, running horizontally and parallel (as parallel as the variations between the 2 readings will permit) across the chart. I have tried using the line graph option in Wizard and that gave me a true Systolic reading representation but the Diastolic reading was that of the Systolic combined with it, which, of course, gave a false, too high reading. Furthermore it appeared that I would not be able to plot readings for much more than 4 consecutive days, at 4 times per day, and make them easy to read and meaningful while I would like to incorporate 14 days of data in one chart. TIA for any suggestions and help.
 
Joined
Jun 26, 2000
Messages
7,762
not a guru, but have done many charts in Excel before.

If you send me the data, or an example of the data that you might be receiving, then I will see if i can make something for you.
 

cwilmot

Thread Starter
Joined
Apr 21, 2001
Messages
676
To: Randy G and abvavguser: Thanks, guys, for the generous offers. I have only 12 days of data collected thus far. I kind of wanted to incorporate 2 more days of data but it isn't mandatory. Do you want me to post the data here or would you rather have me send it to you each personally? If so, I would need your email addresses. It really doesn't matter to me other than the fact that I don't want to clutter up this bulletin board with a lot of raw data. My email address, in case you have any reluctance about posting yours here on the board, is: [email protected] and you can send them directly to me. Please let me know your preferences. Thanks, so much. Chuck
 
Joined
Jun 26, 2000
Messages
7,762
I'v eemailed you the chart in Excel 2000, using Pivot tables and Pivot Charts.


Let me know if it suits, and if you need any explanations on how to use it. Also let me know if you have an older version of Excel, which does not support Pivot Charts.
 
Joined
Oct 3, 2002
Messages
2,281
cwilmot, I have sent you a mail on the address that you gave. You can reply to it and attach the excel file, preferably after zipping.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top