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
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
2 Replies
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.
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.
