I'm looking at doing a timeline chart for sleeping patterns.
The data comes in the following format:
I'm trying to produce a chart which shows the duration of sleep for a user specified 24 hour period that would look somewhat similar to this one: http://raisingchildren.net.au/verve/...es/sleep_1.gifPlease Login or Register to view this content.
Currently I have only come across using methods like the stacked bar chart and hiding the unused sections - similar to this one: http://pubs.logicalexpressions.com/P...cle.asp?ID=343
This requires that I convert the data to a horizontal format and build padding into it for the non-sleep periods.
Does anyone know of another way of doing this? I'd like to avoid using the cell formatting approach as I am working in 1 minute increments and this won't display well with that approach.
Brad.
Bookmarks