Pivot table and graphic

%3CLINGO-SUB%20id%3D%22lingo-sub-1153907%22%20slang%3D%22fr-FR%22%3EPivot%20table%20and%20graphic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1153907%22%20slang%3D%22fr-FR%22%3EHi%3CBR%20%2F%3EI%20have%20a%20pivot%20table%20and%20I%20did%20a%20graphic%20in%20the%20pivot%20table.%20I%20wanted%20to%20know%20how%20can%20I%20remove%20some%20value%20in%3CBR%20%2F%3Emy%20graphic%20whitout%20that%20it%20removes%20from%20the%20table%20Thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1153907%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1160609%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20and%20graphic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1160609%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F546519%22%20target%3D%22_blank%22%3E%40Jasmine2470%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20afraid%20without%20a%20sample%20of%20your%20workbook%20(or%20at%20least%20more%20description)%20it%20would%20be%20difficult%20for%20any%20of%20us%20in%20the%20community%20to%20be%20able%20to%20provide%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1268446%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20and%20graphic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1268446%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F546519%22%20target%3D%22_blank%22%3E%40Jasmine2470%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20suggest%20this%20trick%3A%3C%2FP%3E%3CP%3ECreate%202%20pivot%20tables.%3C%2FP%3E%3CP%3EUse%20one%20for%20showing%20the%20data%3C%2FP%3E%3CP%3EUse%20the%20second%20one%20(you%20can%20hide%20it%20in%20a%20different%20tab%20or%20outside%20the%20print%20area)%20for%20generating%20your%20chart.%3C%2FP%3E%3CP%3EAnd%20voila!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20to%20filter%20both%2C%20pivot%20table%20and%20graphs%2C%20with%20the%20same%20slicer.%20You%20can%20then%20link%20the%20Filter%20Slicer%20to%20both%20pivot%20tables.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
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
2 Replies
Highlighted

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.

Highlighted

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.