F
Fred Grange
I am seeking assistance to build a chart or graph to illustrate delivery
times each day over a year period.
Each truck delivers 0 to 10 loads each day, 5 or 6 days a week,
The date and time each load is received is logged in a database.
The earliest delivery is 7AM, the latest is 5PM.
Perhaps the verticle axis might represent hours of the day from 7-5PM.
The horizantal axis might represent the days of the week, all 365 days of
the year.
An alternative would be to delete Sundays as no loads are delivered on Sunday.
This might be a scatter chart, or a high-low chart with provision for loads
in between.
What are your suggestions?
The database might populate a dot representing the time of day eack load was
received.
Our objective is to show a trend of the earliest, latest, number of
deliverys per day.
We are trying to show this for seven different trucks, both seperatly, and
combined.
We can provide the raw data in deliminated format. What would you charge to
create the visuals? Phone me.
--
Fred Grange
2333 Kerner Blvd.
San Rafael, Calif. 94901
Phone 415-456-2712 x206
e-mail: (e-mail address removed)
times each day over a year period.
Each truck delivers 0 to 10 loads each day, 5 or 6 days a week,
The date and time each load is received is logged in a database.
The earliest delivery is 7AM, the latest is 5PM.
Perhaps the verticle axis might represent hours of the day from 7-5PM.
The horizantal axis might represent the days of the week, all 365 days of
the year.
An alternative would be to delete Sundays as no loads are delivered on Sunday.
This might be a scatter chart, or a high-low chart with provision for loads
in between.
What are your suggestions?
The database might populate a dot representing the time of day eack load was
received.
Our objective is to show a trend of the earliest, latest, number of
deliverys per day.
We are trying to show this for seven different trucks, both seperatly, and
combined.
We can provide the raw data in deliminated format. What would you charge to
create the visuals? Phone me.
--
Fred Grange
2333 Kerner Blvd.
San Rafael, Calif. 94901
Phone 415-456-2712 x206
e-mail: (e-mail address removed)