Graph for multiple staff by week number

[sknight22]

Hello,

I've really tried to figure this out by googling and struggling. I have a database of drivers which is in order of week number 1 - 52 along the top and their MPG (miles per gallon) per week. (as below).

I wondered is it possible to put this into a graph, ideally or some kind of table to show their individual weekly progress from the previous week.

Any ideas? I cant get the chart option to work.


[TABLE="width: 578"]
<colgroup><col><col span="4"><col span="2"></colgroup><tbody>[TR]
[TD]Driver[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Name 1 [/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.27[/TD]
[TD]9.50[/TD]
[TD]8.85[/TD]
[TD]8.48[/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD]0.00[/TD]
[TD]8.94[/TD]
[TD]8.93[/TD]
[TD]9.28[/TD]
[TD]9.01[/TD]
[TD]9.23[/TD]
[/TR]
[TR]
[TD]Name 3[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Name 4[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Name 5[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.94[/TD]
[TD]8.93[/TD]
[/TR]
[TR]
[TD]Name 6[/TD]
[TD]0.00[/TD]
[TD]10.33[/TD]
[TD]9.93[/TD]
[TD]10.49[/TD]
[TD]9.07[/TD]
[TD]9.07[/TD]
[/TR]
[TR]
[TD]Name 7[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.20[/TD]
[TD]8.59[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 842"]
<colgroup><col><col span="4"><col span="6"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jäger]

Hello,

I've really tried to figure this out by googling and struggling. I have a database of drivers which is in order of week number 1 - 52 along the top and their MPG (miles per gallon) per week. (as below).

I wondered is it possible to put this into a graph, ideally or some kind of table to show their individual weekly progress from the previous week.

Any ideas? I cant get the chart option to work.


[TABLE="width: 578"]
<tbody>[TR]
[TD]Driver[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.27[/TD]
[TD]9.50[/TD]
[TD]8.85[/TD]
[TD]8.48[/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD]0.00[/TD]
[TD]8.94[/TD]
[TD]8.93[/TD]
[TD]9.28[/TD]
[TD]9.01[/TD]
[TD]9.23[/TD]
[/TR]
[TR]
[TD]Name 3[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Name 4[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Name 5[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.94[/TD]
[TD]8.93[/TD]
[/TR]
[TR]
[TD]Name 6[/TD]
[TD]0.00[/TD]
[TD]10.33[/TD]
[TD]9.93[/TD]
[TD]10.49[/TD]
[TD]9.07[/TD]
[TD]9.07[/TD]
[/TR]
[TR]
[TD]Name 7[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.20[/TD]
[TD]8.59[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 842"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Have you tried quick & easy pivot chart, i populated one with your data (added more data for the fuel) placed the driver under the Axis & weeks under the vales, end result was a visual bar graph. You can edit the chart elements once created.

 

[sknight22]

Have you tried quick & easy pivot chart, i populated one with your data (added more data for the fuel) placed the driver under the Axis & weeks under the vales, end result was a visual bar graph. You can edit the chart elements once created.

Thank you for your response - I have tried a few times to put it into a pivot but it didnt like the layout of the data source - I'll try again and see if I can get the same result as you.

Thanks Again