Please help me create charts to analyse my self-tacking data.
July 19, 2010 3:15 PM Subscribe
How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist?
posted by razzman to Computers & Internet (6 answers total) 17 users marked this as a favorite
The android app (keeptrack) is great and I'm not finding it a problem at all to input the data but reporting in a meaningful way is proving really difficult.
The data exports as a delimited text file in the format below....watches are what the program calls the things I'm tracking.
12/07/2010 23:48 7
13/07/2010 16:49 3
14/07/2010 23:58 4
15/07/2010 22:51 1
16/07/2010 23:10 5
12/07/2010 22:42 2
13/07/2010 18:50 5
14/07/2010 20:40 3
15/07/2010 21:32 3
16/07/2010 23:18 4
How can I chuck in multiple types of 'watches' with multiple dates/scores into a program and get it to graph it all on the same chart?
I would want as many as 9 or 10 different 'watches'. Then I could see, as an example, if alcohol units on 1 day led to stress problems the next day and see how this was related to hours slept.
I've tried to use excel but find adding the second series problematic. I'm happy to learn what to do but can't understand the terminology to search for a tutorial and don't really want to have to learn everything about excel charts. I would much prefer an offline app but could bring myself to use an online app if necessary.