Graphs! Graphs! Graphs?

[Jäger]

Hi all,

I have recently been dropped with this on my desktop & told "make it into a graph" no amount of "I have no idea" doesn't compute with the hierarchy. Long shot but can anyone help or point me in the right direction?

History for the below is as described, the below data represents logging trucks per hour with totals at the bottom of each day, along with averages for that day. What they want to see is a bar graph showing total for the day along with a trend line representing the average truck per day. They also added “don’t forget to add volume & average along side of each day” data below. Can any one point me in a direction of even the basic's?

July	1-Jul	2-Jul	3-Jul	4-Jul	5-Jul	6-Jul	7-Jul	8-Jul	9-Jul	10-Jul	11-Jul	12-Jul	13-Jul	14-Jul	15-Jul	16-Jul	17-Jul	18-Jul	19-Jul
05:00 - 06:00					5			2	5	7	8	5			0	6	5
06:00 - 07:00					3			0	2	2	2	2			1	2	2
07:00 - 08:00					2			0	2	2	0	2			2	1	1
08:00 - 09:00					4			5	10	5	6	1			3	5	5
09:00 - 10:00					8			5	3	6	8	2			4	9	5
10:00 - 11:00					4			4	5	7	6	4			7	4	4
11:00 - 12:00					1			3	5	4	4	4			0	3	1
12:00 - 13:00					5			3	3	4	4	2			4	4	3
13:00 - 14:00					5			2	4	3	3	0			3	4	4
14:00 - 15:00					6			3	6	7	5	0			4	3	6
15:00 - 16:00					5			9	11	4	8	2			3	4
16:00 -17:00					2			4	5	6	5	2			3	4
Total trucks	0	0	0	0	50			40	61	57	59	26			34	49	36	0	0
Average p/h		0.00	0.00	0.00	4.17			3.33	5.08	4.75	4.92	2.17			2.83	4.08	3.60	0.00	0.00
Total Volume					1441.73			1219.36	1888.27	1768.39	1690.88	731.87			1031.24	1454.89
AverageVolume p/h	0	0	0	0	120.14			101.613	157.35	147.366	140.90	60.98			85.93	121.24	0	0	0

<tbody>
</tbody>