Thread: timeline chart

I'm looking at doing a timeline chart for sleeping patterns.

The data comes in the following format:

Code:

Date		Activity	From	To
2/03/2010	Sleep		21:30	02:40
3/03/2010	Sleep		03:30	06:00
3/03/2010	Sleep		10:20	13:45
3/03/2010	Sleep		15:30	15:50
3/03/2010	Sleep		17:52	18:15

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.gif

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.

Thanks rwgrietveld

I'm actually familiar with the standard project management style gantt charting for excel. However, the one i'm looking to create has those 5 bars on the same line rather than on their own separate row in the chart - if that makes sense.

Brad

Originally Posted by rwgrietveld

So 2/03/2010 on 1 line (1 period)
and 3/03/2010 on the second (4 periods)?

Pretty much. I'm hoping to make it dynamic so the user specifies a 24 hour period that they wish to view. I would then need to make sure the very first record has midnight ("00:00") as the From time - unless I can use a charting method that has date scaling ability.

Originally Posted by rwgrietveld

You must look at GANT CHARTS. Lots of stuff on the internet.

here is yours. make a duration column with mod(D2-C2,1) and add that to bar chart. First stacked column is set to no fill (Transparent)

This looks good but I'm wondering if there's a way to capture multiple sleep/wake episodes in a single 24 hour period.