topic Re: Modify Pie chart to show wedges in descending order of % in Discussions

Modify Pie chart to show wedges in descending order of %

GZ7853 — Thu, 13 Dec 2018 15:55:39 GMT

I have been able to generate a pie chart based on some sales data. Is there a way to display the wedges in descending order? Wedges are representative of sums of individual parts into grouped into a higher level category. See cahart below.

Re: Modify Pie chart to show wedges in descending order of %

GZ7853 — Thu, 13 Dec 2018 17:04:31 GMT

As a short term fix, I was able to use Value Ordering to order the largest wedges. However, this could be very tedious to sort the entire list of wedges. I guess this becomes a request on how to autorank these to save the time spent on manual sorting.

Re: Modify Pie chart to show wedges in descending order of %

txnelson — Thu, 13 Dec 2018 18:49:46 GMT

I suggest you familiarize youself with the column property "Row Level Ordering". That may be able to be used.

Re: Modify Pie chart to show wedges in descending order of %

Mark_Bailey — Thu, 13 Dec 2018 18:54:00 GMT

Did you try right-clicking on the Customer Invoice Qty axis and select Order By command?

Re: Modify Pie chart to show wedges in descending order of %

markschahl — Fri, 14 Dec 2018 10:54:08 GMT

Visualizations superior to pie chart:

Analyze > Quality & Process > Pareto Plot (automatically sorted)

Packed Bars: https://community.jmp.com/t5/JMP-Blog/Introducing-packed-bars-a-new-chart-form/ba-p/39972

#onelesspie