Multiple charts from single table

sreed39

New Member
Joined
Nov 2, 2017
Messages
25
Office Version
  1. 365
Platform
  1. Windows
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)

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:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,215,043
Messages
6,122,822
Members
449,096
Latest member
Erald

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top