To create a chart in an Excel report sheet ... the source sheet into your pivot table. The pivot table collates all of the data for multiple items by adding them (by default).

and connect multiple pivot tables from the top menu. It’s one of the effective ways to maximize productivity in Excel. Once your pivot charts are ready, create another sheet called a dashboard ...