Feb 05 2020 01:44 PM
Feb 07 2020 01:23 PM
Hello @Jasmine2470,
I'm afraid without a sample of your workbook (or at least more description) it would be difficult for any of us in the community to be able to provide any assistance.
Mar 31 2020 08:49 AM
Hi @Jasmine2470
I would suggest this trick:
Create 2 pivot tables.
Use one for showing the data
Use the second one (you can hide it in a different tab or outside the print area) for generating your chart.
And voila!
If you need to filter both, pivot table and graphs, with the same slicer. You can then link the Filter Slicer to both pivot tables.