Jegan.K 0 Newbie Poster

Dear All,

Our requirement is a cab has assigned to Pick and Drop the employee for each and every shifts for the selective date. So, we need to show how much distance a cab has travelled, then we need to show that cab has been assigned for Pick/Drop for all the selective date.

As per my Procedure we can get the "Shift Date Time", "Cab No", "Pick/Drop" value, etc....

In Range Column Chart I need to show the "Shift Time" in "X Axis" like "9 AM", "10 AM", "11 AM".....upto Next day "8 AM".
then In "Y Axis" I need to show "Shift Date Time" & "Cab No." which come from table.

In "Y Axis" i can not show the "Shift Date Time", So, I tried to show in "X Axis", but I can show only shift Date not time.
Actually I need to show the shift date in "Y Axis" only.

If any one have the solution, Please reply me.

Thanks in Advance.

Regards,
Jegan.K
9994388922