Point in time charts

[#1]

I create some point in time charts based on time rather than date .

I have various objects that  has 5 stages, (Stage 1,2,3,4 and 5)  that is needs to go through and each of these stages have a time stamp when acheived what I want to plot if possible is a stacked bar chart which shows the stages the object has passed through against the timeline

the axis I want are

Object Name

time (e.g current time plus or minus 1 hr)

with the stage values displayed as a stacked bar chart (grouped by object Name)

Hope this makes sense

[#2]

Sue,

Is your data model ready?

Do you have 5 columns for stagetimes, like: stage1_time, stage2_time, ....

or rather 5 rows for each object with stage_number and time fields?

regards

Darek

[#3]

The current data is set up as the later so rows for each object with stage_number and time fields

But I am currently working on producing a demo so can easily change this if this is a better way of working

[#4]

Sue,

here is example for you with both data models.

regards

Darek