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)

[TABLE="width: 641"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Truck
[/TD]
[TD]Driver Name
[/TD]
[TD]LFA1
[/TD]
[TD]LFA2
[/TD]
[TD]LFA3
[/TD]
[TD]LFA4
[/TD]
[TD]LFB1
[/TD]
[TD]LFB2
[/TD]
[TD]LFB3
[/TD]
[TD]LFB4
[/TD]
[/TR]
[TR]
[TD]5/22/2018
[/TD]
[TD]1407
[/TD]
[TD]McCarrick, Mike`
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]5/22/2018
[/TD]
[TD]1491
[/TD]
[TD]McCarrick, Mike`
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[TD]12
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]6/23/2018
[/TD]
[TD]1491
[/TD]
[TD]Hamelin, Matt
[/TD]
[TD]11
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[TD]9
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[TD]12
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]5/22/2018
[/TD]
[TD]1530
[/TD]
[TD]Lipe, Brad
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]15
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]6/23/2018
[/TD]
[TD]1530
[/TD]
[TD]Vic & Ed S.
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]13
[/TD]
[TD]10
[/TD]
[TD]15
[/TD]
[TD]12
[/TD]
[TD]14
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]1/10/2018
[/TD]
[TD]1605
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]15
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]2/16/2018
[/TD]
[TD]1605
[/TD]
[TD]Hernandez, Tino
[/TD]
[TD]12
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]2/23/2018
[/TD]
[TD]1605
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]5/22/2018
[/TD]
[TD]806585
[/TD]
[TD][/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]15
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]6/23/2018
[/TD]
[TD]806585
[/TD]
[TD]Vic & Ed S.
[/TD]
[TD]13
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]15
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]1/12/2018
[/TD]
[TD]BP9491
[/TD]
[TD]Walker, Joe
[/TD]
[TD]16
[/TD]
[TD]14
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[/TR]
[TR]
[TD]1/28/2018
[/TD]
[TD]BP9491
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]2/8/2018
[/TD]
[TD]BP9491
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]13
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]2/16/2018
[/TD]
[TD]BP9818
[/TD]
[TD]McCarrick, Mike`
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]17
[/TD]
[/TR]
[TR]
[TD]2/21/2018
[/TD]
[TD]BP9818
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]2/23/2018
[/TD]
[TD]FE9328
[/TD]
[TD]Lipe, Brad
[/TD]
[TD]16
[/TD]
[TD]14
[/TD]
[TD]11
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]3/16/2018
[/TD]
[TD]FE9328
[/TD]
[TD]McCarrick, Mike`
[/TD]
[TD]13
[/TD]
[TD]9
[/TD]
[TD]10
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]11
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]3/27/2018
[/TD]
[TD]FE9328
[/TD]
[TD][/TD]
[TD]14
[/TD]
[TD]11
[/TD]
[TD]12
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]11
[/TD]
[TD]12
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]6/23/2018
[/TD]
[TD]FE9328
[/TD]
[TD]Brad & Lorraine
[/TD]
[TD]11
[/TD]
[TD]13
[/TD]
[TD]14
[/TD]
[TD]14
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]4/5/2018
[/TD]
[TD]JU1938
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]21
[/TD]
[/TR]
[TR]
[TD]5/22/2018
[/TD]
[TD]JU1938
[/TD]
[TD]Lipe, Brad
[/TD]
[TD]19
[/TD]
[TD]18
[/TD]
[TD]18
[/TD]
[TD]7
[/TD]
[TD]18
[/TD]
[TD]18
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]3/16/2018
[/TD]
[TD]ZZ1032
[/TD]
[TD][/TD]
[TD]20
[/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[/TR]
[TR]
[TD]3/22/2018
[/TD]
[TD]ZZ1032
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]22
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]22
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[/TR]
[TR]
[TD]4/11/2018
[/TD]
[TD]ZZ1037
[/TD]
[TD]Lipe, Brad
[/TD]
[TD]21
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]2/9/2018
[/TD]
[TD]ZZ1459
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]21
[/TD]
[/TR]
[TR]
[TD]3/16/2018
[/TD]
[TD]ZZ1459
[/TD]
[TD][/TD]
[TD]22
[/TD]
[TD]22
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]4/5/2018
[/TD]
[TD]ZZ1459
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]20
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]20
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]4/18/2018
[/TD]
[TD]ZZ1459
[/TD]
[TD]McCarrick, Mike`
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]19
[/TD]
[TD]18
[/TD]
[TD]18
[/TD]
[TD]19
[/TD]
[/TR]
[TR]
[TD]3/16/2018
[/TD]
[TD]ZZ3057
[/TD]
[TD]McCarrick, Mike`
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]4/5/2018
[/TD]
[TD]ZZ3057
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]6/23/2018
[/TD]
[TD]ZZ3057
[/TD]
[TD]Brad & Lorraine
[/TD]
[TD]13
[/TD]
[TD]9
[/TD]
[TD]11
[/TD]
[TD]12
[/TD]
[TD]13
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]2/9/2018
[/TD]
[TD]ZZ3058
[/TD]
[TD]Lipe, Brad
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]11
[/TD]
[TD]11
[/TD]
[TD]13
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]11
[/TD]
[/TR]
[TR]
[TD]2/22/2018
[/TD]
[TD]ZZ3058
[/TD]
[TD]Hernandez, Tino
[/TD]
[TD]11
[/TD]
[TD]9
[/TD]
[TD]9
[/TD]
[TD]8
[/TD]
[TD]11
[/TD]
[TD]12
[/TD]
[TD]9
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]3/16/2018
[/TD]
[TD]ZZ3058
[/TD]
[TD]Hernandez, Tino
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[TD]17
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[TD]17
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]3/27/2018
[/TD]
[TD]ZZ3058
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[TD]17
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]17
[/TD]
[TD]17
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]4/11/2018
[/TD]
[TD]ZZ3058
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]15
[/TD]
[TD]16
[/TD]
[TD]16
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]6/23/2018
[/TD]
[TD]ZZ44644
[/TD]
[TD]Hamelin, Matt
[/TD]
[TD]10
[/TD]
[TD]13
[/TD]
[TD]13
[/TD]
[TD]10
[/TD]
[TD]9
[/TD]
[TD]9
[/TD]
[TD]9
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]3/16/2018
[/TD]
[TD]ZZ9996
[/TD]
[TD]Hernandez, Tino
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[/TR]
[TR]
[TD]3/27/2018
[/TD]
[TD]ZZ9996
[/TD]
[TD]Kierstead, Doug
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]21
[/TD]
[TD]21
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,223,908
Messages
6,175,304
Members
452,633
Latest member
DougMo

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