View Single Post
  #24   Report Post  
Posted to uk.d-i-y
Mary Fisher Mary Fisher is offline
external usenet poster
 
Posts: 3,212
Default Computer question


"Roger Mills" wrote in message
...
In an earlier contribution to this discussion,
Owain wrote:

Mary Fisher wrote:
I want to mark a particular event which happens every couple of
weeks or so into a graph form so that its regularity or otherwise
can easily be seen. I could do it with a & b axes on graph paper but
I don't want to have to do it with pencil and paper (because I'd
lose it).


Excel (or any other spreadsheet - does Google have an online one?)

Col. A = date
Col. B = event (put a 1 in for event otherwise leave blank)

Then you can get a graph of dates along the bottom axis and value 0-1
along the side axis, with bars of value 1 for each time the event
happens.


As a further refinement - if she was recording, for example, every time
she was ravished by 'spouse' then, instead of using a '1' she could use a
variable number which reflected the quality of the event. g


I don't need a graph for that, there wouldn't be enough cells.

If you really want to know (it's boring) it's about a medical condition I
have and I want to record incidents as a graph so that I can see if they are
increasing or decreasing over time.

Mary