Background: I've been having some sleep issues so I have started tracking my sleep habits along with some other data but so far, they are just entries in Evernote and as such it is not possible to see any patterns. Obviously I need a spreadsheet app with charting capabilities (doh!). I've been using a great iPhone app called Sleepbot for data collection for sleep times and then enter those into Evernote.
I have the iWork set so I have been looking at Numbers and going through some tutorials but I still can't tell if it will do what I want. Given that my data set will increase daily, I'd like to be able to "page through" a chart/data set, so it shows say the last 30 data entries. With all the tutorials I have seen, the charts are of fixed size and adding more data to a linked table just causes the chart to cram more stuff in.
Can Numbers do this sort of "paging" of data? I would like to have this sort of "on the fly" charting rather than having to explicitly build a chart each time I want to visualize the data.
(sorry the question is rather garbled: I don't know really anything about using a spreadsheet type app)