Question on pareto plots

Question

Hi Guys,

I have four columns in my data table. They are:
Name, Total,Count and %.

The % column is calculated as Count/Total. The name has test1, test2, etc.

Here is an example:

Name    Total  Count    %
Test1    5666   666      11.75
Test2    777     23        2.96
Test3    888     22        2.47

I am trying to plot a pareto with Count on the Y axis and Name on the X axis. I have got it working and it shows me the counts for all the tests in the form of bars arranged in a descending format.

I want to see % instead of counts. I used the red triangle to convert it into a % scale and it showed the % but they were calculated say for test1 it should me 93% instead of 11.75%.

I want to see a pareto which has the test names on the X axis with the bars plotted from highest % (of Total) to lowest %.

How can I do that? 
Thanks.

chungwei · Answer

You can assign the column property "Row Order Levels" to your "Name" column.
Do the chart after the sort. Chart will display the groups in the order they appear in the data table.

unknown · Answer

That's a good point!  Sorting the data table by the % column doesn't change the display order of the bars.  I don't know if there is another way??

So, plan B.  Back to the pareto plot.  There is a "weight" role in the pareto plot dialog.  You can use this role to adjust for the fact that the different counts are derived from different size totals.  Create a new column and call it something like weight.  Assign the following formula

weight = 1 / total

(or weight = 100 / total ) depending on whether you want fractions or percentages.

Assign column 'name' to 'y,cause'
Assign column 'weight' to 'weight'
Assign column 'count' to 'freq'

unknown · Answer

Ok thanks for the info. I used a chart option and it worked. How do I get the bars to be sorted in a descending order? I want the highest % to show up as the leftmost bar.