Numbers...How to graph vs time of day

Discussion in 'iPad General Discussions' started by larrycruzen, Aug 30, 2014.

  1. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    55
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    I have a 3 column chart: Time of day (independent variable), systolic & diastolic pressures (dependent variables). Time of day is random, inserted using the "NOW" button. I plot this data daily on a simple 2D line graph. The X axis always plots in constant increments.

    Is there a way to get the spacing on this axis to vary in accordance with the random times of day?

    Larry Cruzen
     
  2. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    18,569
    Thanks Received:
    3,442
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +4,379 / 4
    The only way I can think of is to pre-create a row for each time you need to record. Depending on how granular you need this to be it could be morning/noon/evening, or hourly (one row per hour).

    That, of course, can make for some really long tables.

    I once created a time chart using the table itself. I created a column for each 30 minute's of a day, along a row. I doubt this would server your needs, but it might give you some ideas.

    https://app.box.com/s/c36mqqil473710nlqv2t

    There are values in the cells, for computation purposes, but I made them the same color as the cell background so they would not distract. I image you'd want to do the opposite. Though you could change the background colors of the cells to reflect high/good/low blood pressures results.
     
    • Informative Informative x 1
    • List
  3. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    55
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    Thank you.

    I was thinking that what I need to use is a scatter plot, but I don't one in Numbers.

    Larry Cruzen
     
  4. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    18,569
    Thanks Received:
    3,442
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +4,379 / 4
    I hadn't thought of that. The latest version of Numbers does support scatter charts; both static and interactive.

    I really need to explore the new chart types and find out what I can do with them.
     
  5. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    55
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    Well, thanks again. I know that there are updates available for both NUMBERS and PAGES, but, I have no broadband available where I live to download them. Next time I get into a civilized area I will update all of my apps.
     
  6. Gtatler

    Gtatler iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    458
    Thanks Received:
    53
    Trophy Points:
    28
    Location:
    UK
    Ratings:
    +86 / 1

    There are several apps on the app store which are used for keeping track of blood pressure results, some free, some paid. I use BPCompanion which is free and very good. There is also a paid version which can deal with multiple users. Graphing is a feature of all of them. Suggest you might like to investigate,


    Sent from my iPad using Tapatalk
     
  7. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    55
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    Now, why didn't I think to look for an app for this purpose!

    Thank you very much.

    I have downloaded this app and am experimenting with it.

    Have you found a way to add comments to a data point, such as "after vigorous exercise"?

    Larry Cruzen
     
  8. Gtatler

    Gtatler iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    458
    Thanks Received:
    53
    Trophy Points:
    28
    Location:
    UK
    Ratings:
    +86 / 1
    Larry Cruzen

    Negative. However it does include heart rate, vigorous exercise would presumably increase this.


    Sent from my iPad using Tapatalk
     
  9. n4uau

    n4uau iPad Enthusiast

    Joined:
    Nov 19, 2012
    Messages:
    337
    Thanks Received:
    34
    Trophy Points:
    28
    Location:
    United States
    Ratings:
    +41 / 0
    Your reply about no comments is odd as I notice the second entry under features for that app is "add note to the readings"!
     
  10. Gtatler

    Gtatler iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    458
    Thanks Received:
    53
    Trophy Points:
    28
    Location:
    UK
    Ratings:
    +86 / 1
    Ooppss ! Do you know I have been using this app for months and never noticed that the new data entry screen has 3 separate sections. One to enter timed and dated bp readings and heartrate, another to add weight, and finally to add a short note. I suppose it's a case of you only use an app as you want to. If a note is added it appears at the right of the screen, and ALL data can be exported in a variety of ways including xls and pdf files. Wow. That makes it even more of a useful tool. Sorry I misled people.


    Sent from my iPad using Tapatalk
     
  11. n4uau

    n4uau iPad Enthusiast

    Joined:
    Nov 19, 2012
    Messages:
    337
    Thanks Received:
    34
    Trophy Points:
    28
    Location:
    United States
    Ratings:
    +41 / 0
    I find that often if you spend some time just exploring what an app can do, it often will do a lot more than you first thought.
     
  12. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    55
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    When someone recommends a free app of interest to me, I generally just download it and dive into it. If I can't readily figure it out, delete it.

    In the case of BP COMPANION, it was straightforward and intuitive. Don't like entering numbers with a dial, though. I can enter 3 digits faster & more accurately by typing them in.

    Larry Cruzen
     
  13. Elizellen

    Elizellen iPad Fan

    Joined:
    Jul 19, 2011
    Messages:
    193
    Thanks Received:
    30
    Trophy Points:
    28
    Location:
    Bournemouth UK
    Ratings:
    +32 / 0
    I've just downloaded the free version for myself - thanks for mentioning it!

    Does anyone know if it is possible to put previous readings in or does it only log numbers for the current date/time?
     
  14. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    55
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    You can "spin" the date back in time.....just tried it to make sure.

    Larry Cruzen
     
  15. Elizellen

    Elizellen iPad Fan

    Joined:
    Jul 19, 2011
    Messages:
    193
    Thanks Received:
    30
    Trophy Points:
    28
    Location:
    Bournemouth UK
    Ratings:
    +32 / 0
    Thank you, Larry!
     

Share This Page

Search tags for this page

simple graph apple numbers