Plotting question
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Plotting question
I have been plotting my systolic and diastolic for my doctor they are in the format sss/dd. I would like to plot them but I would like to use Excel to detach the two numbers from the text. I could do it with two columns of text formulas. But I would like to simplify the tast.
Any suggestions?
Any suggestions?
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Plotting question
You can also use Data > Text to Columns. Specify Delimited, then specify / as delimiter.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
Ok but I was trying to graph without that step. Any way to do that, have the series a formula to break it apart?
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 151
- Joined: 11 Jun 2012, 20:37
Re: Plotting question
But you may be able to do it behind the scenes.
The attached has a proper Excel 'table' at cell A1 which you can add to.
There are 2 defined Names (Sys and Dia) which are used in the chart series.
As long as the table extent covers the data you want (see the grab handle, a small triangle, in the bottom right hand corner of the bottom right cell of the table) the chart should plot your values.
It complains with a 'Excel has found a problem with one or more formula references…' , but dismissing this with OK and ignoring it seems to sort it.
The attached has a proper Excel 'table' at cell A1 which you can add to.
There are 2 defined Names (Sys and Dia) which are used in the chart series.
As long as the table extent covers the data you want (see the grab handle, a small triangle, in the bottom right hand corner of the bottom right cell of the table) the chart should plot your values.
It complains with a 'Excel has found a problem with one or more formula references…' , but dismissing this with OK and ignoring it seems to sort it.
You do not have the required permissions to view the files attached to this post.
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
That is great but I have a procedure question.
1. I have an older edition of Excel 2007 and I'm not sure that I have a grab handle, small triangle on a sheet, at least I don't remember seeing these.
I assume that once the graph has been created then any additions would be handled by enlarging the "series" range.
1. I have an older edition of Excel 2007 and I'm not sure that I have a grab handle, small triangle on a sheet, at least I don't remember seeing these.
I assume that once the graph has been created then any additions would be handled by enlarging the "series" range.
-
- 2StarLounger
- Posts: 151
- Joined: 11 Jun 2012, 20:37
Re: Plotting question
I'd be surprised if you haven't got a grab handle but I will try and check. Either way the table should expand/contract by itself as you add/delete data at the bottom. Did the file I attached have a grab handle?
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
If you are referring to a small plus sign as a grab handle then yes it does.
Thanks
Thanks
-
- 2StarLounger
- Posts: 151
- Joined: 11 Jun 2012, 20:37
Re: Plotting question
Trawling around the internet the Excel 2007 grab handle should be something like:
which when zoomed in isn't a triangle but this: but to see it the selected cell(s) has to be inside the table.
which when zoomed in isn't a triangle but this: but to see it the selected cell(s) has to be inside the table.
You do not have the required permissions to view the files attached to this post.
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
I guess my comment need to be addressed to a range of cells on a spreadsheet exclusive of a graph series and I never noticed the difference.
Thanks for an education.
PS This is my spreadsheet breaking apart the text into two numbers as you may see in column "F" and "G"
Thanks for an education.
PS This is my spreadsheet breaking apart the text into two numbers as you may see in column "F" and "G"
You do not have the required permissions to view the files attached to this post.
-
- 2StarLounger
- Posts: 151
- Joined: 11 Jun 2012, 20:37
Re: Plotting question
So you're sorted now and need no further help/sugestions?
-
- UraniumLounger
- Posts: 9295
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Plotting question
#bknight
I hope you won't be offended by this suggestion.
You might want to record the time of day when you take your BP in a column. I did what you are doing some time back after having had some stents placed and an atrial flutter. My cardiologist wanted the TOD and the TOD when I took morning and evening meds in addition to the BP data.
I hope you won't be offended by this suggestion.
You might want to record the time of day when you take your BP in a column. I did what you are doing some time back after having had some stents placed and an atrial flutter. My cardiologist wanted the TOD and the TOD when I took morning and evening meds in addition to the BP data.
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
Well the dynamic range calculating 3 day moving average has stopped auto filling the auto ranges for both sys and dia are still working. How to correct the 3 day auto filling, without disturbing the sys and dia ranges? I have changed nothing on the spreadsheet to my knowledge with the exception of filling out a lot of data since the last post.
You do not have the required permissions to view the files attached to this post.
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
One more day of movingAvg not filling in. I don't know how to set it to auto fill in, nor do I remember why it stopped around the first of the year.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
I posted the data manager yesterday, however you have mail.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Plotting question
Select the last cell with a 3 Day Moving Average.
Click and hold the fill handle (the little square in the lower right corner of the cell) and drag it down a few hundred rows, then release the mouse button.
You'll be good to go for another year or so.
Click and hold the fill handle (the little square in the lower right corner of the cell) and drag it down a few hundred rows, then release the mouse button.
You'll be good to go for another year or so.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1400
- Joined: 08 Jul 2016, 18:53
Re: Plotting question
To where I selected gets me to Jul, and I hope to remember what to do when it stops working.