Conference Call Report

his may be in the wrong forum, but I'm going to give it a shot anyways. Here goes.

I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24.

I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour.

Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting.

What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph.

To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back.

If you want to look at what we have now visit www.acorsys.com/test.gif.

If you would like some code on what I have now just ask or email me at ddamian@acorsys.com. Thanks.