Numbers...How to graph vs time of day

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

  1. larrycruzen

    larrycruzen
    Expand Collapse
    iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    80
    Thanks Received:
    9
    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
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,315
    Thanks Received:
    5,876
    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
    Expand Collapse
    iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    80
    Thanks Received:
    9
    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
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,315
    Thanks Received:
    5,876
    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
    Expand Collapse
    iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    80
    Thanks Received:
    9
    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
    Expand Collapse
    iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    487
    Thanks Received:
    69

    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
    Expand Collapse
    iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    80
    Thanks Received:
    9
    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
    Expand Collapse
    iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    487
    Thanks Received:
    69
    Larry Cruzen

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


    Sent from my iPad using Tapatalk
     
  9. n4uau

    n4uau
    Expand Collapse
    iPad Enthusiast

    Joined:
    Nov 19, 2012
    Messages:
    349
    Thanks Received:
    38
    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
    Expand Collapse
    iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    487
    Thanks Received:
    69
    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
     

Share This Page



Search tags for this page

simple graph apple numbers