Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fred Grange
 
Posts: n/a
Default I pay $ for this project

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:
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"