How to Make Charts and Tables for an Excel ... ll see the data imported from the source sheet into your pivot table. The pivot table collates all of the data for multiple items by adding them ...