Pivot - Pareto

Copper Contributor

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

 

Thank you in adavance, Monja.

2 Replies

@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.

Hi @Monja5 

 

I attached a sample image of the Pareto chart created with pivot table data as you can see in the image attached.

 

You can use it to create in Microsoft Excel & Office 365.

 

And if you are comfortable with Google Sheets, you can find it here.

 

Qaiser_j_0-1656507532507.png

 

Thanks