Forum Discussion
Pivot table and graphic
Hi I have a pivot table and I did a graphic in the pivot table. I wanted to know how can I remove some value in my graphic whitout that it removes from the table Thank you
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.