creating gantt chart with bar labels

[darelooney]

how to program a gantt chart with these data:

example:
DATE ARRIVE DATE LEAVING location
4/6/08 23:20 5/6/08 0:25 a
4/6/08 23:55 5/6/08 0:40 b
4/6/08 22:05 5/6/08 6:20 c
4/6/08 14:50 5/6/08 6:30 d
5/6/08 0:55 5/6/08 6:45 e
4/6/08 21:00 5/6/08 7:00 f
5/6/08 2:50 5/6/08 9:00 g
5/6/08 3:25 5/6/08 7:40 h


with each gantt chart bar showing the allocated location when the mouse cursor move over each bar graph? any vb codes example??please help thanks

[Andy Pope]

Use a stacked bar chart.
First series is the Date_Arrive value and the second series is the difference between Date_Arrive and Date_Leave. Use formula to calculate this value.

Do you really need the mouse popup stuff?

[darelooney]

yes i do need the pop up....or alternatively if i click the particular cell of the row...the bar for that clicked cell will change its colour to yellow for example (whereas the rest are in purple). Is that possible?

[Andy Pope]

This example uses addition series to plot a hilite bar depending on active row.