Forum Discussion
How to Plot Blood Pressure over date time?
I am trying to plot my husband's blood pressure over date and time.
So that my doctor can see what date he took his blood pressure, what time of day, and I'm going to have to use to top number to do the plot and I was thinking I'd put the full reading in the label somehow, maybe inside the bar if I did bar charting.
I tried doing this having one column with the Date Time format and then the top blood pressure.
I get weird plots. This is some sample data I am trying to plot. Any help greatly appreciated!!
Date Time | Top |
5/25/2024 18:10 | 144 |
5/26/2024 8:15 | 131 |
5/27/2024 10:00 | 149 |
5/27/2024 18:00 | 167 |
5/28/2024 5:45 | 134 |
5/28/2024 21:00 | 152 |
5/29/2024 5:30 | 132 |
5/29/2024 20:30 | 140 |
5/30/2024 6:00 | 135 |
5/30/2024 21:50 | 149 |
5/31/2024 5:50 | 138 |
5/31/2024 18:00 | 138 |
I'd create an XY Scatter chart based on the data. See the attached workbook.
- echangsutCopper Contributor
HansVogelaar Wow - this is perfect! Thank you so much!!! I have never used a scatter plot. I have learned something new about Excel today and my husband has a great tool to review with his Dr!!!