Time Tracking Chart

    Hi


    I'm having a problem with a chart that I would like to make
    I would like to keep track of time when Trucks arrive at our plant
    (the trucks can come 5 days a week )
    so it looks I have a lot of date to put in a chart !
    I have 2 possible solutions to track time (please see attached)
    what do you think is the best way to keep data, furthermore If I try to make a chart
    it does not show any data ( something with the way I track the hour ?)
    And finally what would be an appropiate chart to have an clear overview according you guys?


    any help would be appreciated !

    Re: Build Chart Time Tracking


    hi crombes,


    i'd go for yr solution 1 layout as obviously there are more rows than columns (unless you're using Vista).


    also, you should enter the dates/times as time and not as text, ie. 16:00 and not 16h00


    lastly, i think XY scatter should be a good choice for the overview.

    Cheers
    ___________
    Xlite :sheep:
    [st]All you need to learn VBA is an internet connection and Ozgrid.com[/st]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login