Pivot - Pareto

%3CLINGO-SUB%20id%3D%22lingo-sub-3508800%22%20slang%3D%22en-US%22%3EPivot%20-%20Pareto%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3508800%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20create%20a%20Pareto%20chart%20from%20a%20Pivot%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20adavance%2C%20Monja.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3508800%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3509048%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20-%20Pareto%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3509048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1424725%22%20target%3D%22_blank%22%3E%40Monja5%3C%2FA%3E%26nbsp%3BWell%2C%20when%20you%20try%20you%20see%20a%20this%20message%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-06-15%20at%2010.06.01.png%22%20style%3D%22width%3A%20238px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-15%20at%2010.06.01.png%22%20style%3D%22width%3A%20238px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F380478i0E133B98EB90DB2E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-06-15%20at%2010.06.01.png%22%20alt%3D%22Screenshot%202022-06-15%20at%2010.06.01.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESo%20the%20answer%20is%20No.%20You'll%20have%20to%20copy%20the%20data%20to%20a%20location%20outside%20the%20Pivot%20Table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is it possible to create a Pareto chart from a Pivot table?

 

Thank you in adavance, Monja.

1 Reply

@Monja5 Well, when you try you see a this message:

Screenshot 2022-06-15 at 10.06.01.png

So the answer is No. You'll have to copy the data to a location outside the Pivot Table.