I have a set of data that tracks tread depth measurements at multiple points for each truck (64 total measurements per truck, per day); I need to create a set of charts which separates out each truck and tracks their regression over time with the horizontal axis being date and vertical axix being measurement. I can do it the laborious way of creating a chart for each one then updating, or the even more laborious way of having a separate tab for each truck and updating it that way, but I am hoping to do this via a pivot table so I can refresh the data when we update and have the charts then auto update as well.
Ideas? Help? (I tried pasting the data here, but that seems to freeze the process).
Here is a snippet of the data (there are more columns, just using this as an example)
<tbody>
</tbody>
Ideas? Help? (I tried pasting the data here, but that seems to freeze the process).
Here is a snippet of the data (there are more columns, just using this as an example)
Date | Truck | Driver Name | LFA1 | LFA2 | LFA3 | LFA4 | LFB1 | LFB2 | LFB3 | LFB4 |
5/22/2018 | 1407 | McCarrick, Mike` | 12 | 13 | 13 | 13 | 12 | 12 | 13 | 13 |
5/22/2018 | 1491 | McCarrick, Mike` | 14 | 14 | 13 | 12 | 14 | 14 | 14 | 12 |
6/23/2018 | 1491 | Hamelin, Matt | 11 | 12 | 13 | 9 | 12 | 13 | 12 | 9 |
5/22/2018 | 1530 | Lipe, Brad | 13 | 13 | 13 | 13 | 13 | 13 | 15 | 13 |
6/23/2018 | 1530 | Vic & Ed S. | 10 | 10 | 13 | 10 | 15 | 12 | 14 | 12 |
1/10/2018 | 1605 | Kierstead, Doug | 14 | 14 | 14 | 14 | 13 | 14 | 15 | 14 |
2/16/2018 | 1605 | Hernandez, Tino | 12 | 14 | 13 | 14 | 13 | 14 | 14 | 13 |
2/23/2018 | 1605 | Kierstead, Doug | 13 | 13 | 13 | 13 | 13 | 13 | 14 | 13 |
5/22/2018 | 806585 | 13 | 13 | 13 | 15 | 13 | 13 | 14 | 14 | |
6/23/2018 | 806585 | Vic & Ed S. | 13 | 15 | 15 | 13 | 14 | 15 | 13 | 13 |
1/12/2018 | BP9491 | Walker, Joe | 16 | 14 | 16 | 17 | 16 | 16 | 16 | 17 |
1/28/2018 | BP9491 | Kierstead, Doug | 14 | 14 | 14 | 14 | 14 | 13 | 14 | 14 |
2/8/2018 | BP9491 | Kierstead, Doug | 13 | 12 | 12 | 13 | 13 | 12 | 12 | 13 |
2/16/2018 | BP9818 | McCarrick, Mike` | 15 | 16 | 15 | 16 | 16 | 15 | 15 | 17 |
2/21/2018 | BP9818 | Kierstead, Doug | 15 | 16 | 16 | 16 | 16 | 16 | 16 | 16 |
2/23/2018 | FE9328 | Lipe, Brad | 16 | 14 | 11 | 14 | 14 | 12 | 12 | 15 |
3/16/2018 | FE9328 | McCarrick, Mike` | 13 | 9 | 10 | 14 | 14 | 14 | 11 | 14 |
3/27/2018 | FE9328 | 14 | 11 | 12 | 14 | 14 | 11 | 12 | 14 | |
6/23/2018 | FE9328 | Brad & Lorraine | 11 | 13 | 14 | 14 | 15 | 15 | 15 | 15 |
4/5/2018 | JU1938 | Kierstead, Doug | 20 | 20 | 20 | 21 | 21 | 20 | 20 | 21 |
5/22/2018 | JU1938 | Lipe, Brad | 19 | 18 | 18 | 7 | 18 | 18 | 16 | 16 |
3/16/2018 | ZZ1032 | 20 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
3/22/2018 | ZZ1032 | Kierstead, Doug | 22 | 21 | 21 | 21 | 22 | 21 | 21 | 21 |
4/11/2018 | ZZ1037 | Lipe, Brad | 21 | 16 | 16 | 20 | 20 | 16 | 17 | 20 |
2/9/2018 | ZZ1459 | Kierstead, Doug | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 21 |
3/16/2018 | ZZ1459 | 22 | 22 | 21 | 21 | 21 | 21 | 21 | 20 | |
4/5/2018 | ZZ1459 | Kierstead, Doug | 20 | 19 | 19 | 19 | 20 | 19 | 19 | 20 |
4/18/2018 | ZZ1459 | McCarrick, Mike` | 19 | 19 | 19 | 19 | 19 | 18 | 18 | 19 |
3/16/2018 | ZZ3057 | McCarrick, Mike` | 15 | 16 | 16 | 15 | 15 | 16 | 16 | 15 |
4/5/2018 | ZZ3057 | Kierstead, Doug | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 |
6/23/2018 | ZZ3057 | Brad & Lorraine | 13 | 9 | 11 | 12 | 13 | 10 | 10 | 12 |
2/9/2018 | ZZ3058 | Lipe, Brad | 13 | 13 | 11 | 11 | 13 | 12 | 12 | 11 |
2/22/2018 | ZZ3058 | Hernandez, Tino | 11 | 9 | 9 | 8 | 11 | 12 | 9 | 9 |
3/16/2018 | ZZ3058 | Hernandez, Tino | 16 | 17 | 17 | 16 | 16 | 17 | 17 | 16 |
3/27/2018 | ZZ3058 | Kierstead, Doug | 16 | 17 | 17 | 16 | 16 | 17 | 17 | 16 |
4/11/2018 | ZZ3058 | Kierstead, Doug | 15 | 16 | 16 | 16 | 15 | 16 | 16 | 15 |
6/23/2018 | ZZ44644 | Hamelin, Matt | 10 | 13 | 13 | 10 | 9 | 9 | 9 | 8 |
3/16/2018 | ZZ9996 | Hernandez, Tino | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 |
3/27/2018 | ZZ9996 | Kierstead, Doug | 20 | 20 | 20 | 21 | 21 | 20 | 20 | 20 |
<tbody>
</tbody>
Last edited: