Messing around.
In the attached:
Sheet2: Chart and slicer at cell B2. Select the date(s) you want to see in the slicer.
Sheet1: Pivot table that the chart is based upon. That pivot table is based on the data in the first 5 columns of that sheet BUT not directly; that data has been through a Power Query whech feeds the pivot.
|