MS Chart - Problem to display the records in Range Column Chart
-
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 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 Jegan