THURSDAY, APRIL 24, 2014
Font Size
Topic pareto

pareto

Home Forums Old Forums General pareto

This topic contains 4 replies, has 1 voice, and was last updated by Avatar of Mark Sinnicks Sinnicks 11 years, 4 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #36466

    Can someone tell me how to make a pareto on Excel? I only know how to do it on Minitab and my organisation does not have Minitab.
    looking forward to any help
    marianne
     

    #36470

    Write “Category” in a cell and “Value” in the cell next it (of course, you can use the words you want, as “Defect type” and “U$S”). Below them, enter all the categories and their values. Select the whole range (including titles). Go to Data ==> Sort. Make sure that “My list has header row” is checked. In “Sort By” selct “Value” (or the word you used) and check “Descending”. Click “Ok”. Select the whole range again and click on the “Cahrt” button in the toolbar (or go to Insert ==> Chart). Make sure that “Column” is selected as chart type, and that the top left sub-type is selected. Click “Finish” button.

    #36474

    Hi Marianne,
    There is a little more to it than the previous post if you want to see the “bend in the knee”.  You could do a Google Search for “Pareto In Excel” and the 6th link down titled “To Create a Pareto Chart” is a link which details it step by step.
    Since it is not advertising a product for sale I will include the actual web address and hope they don’t edit it out.
    http://gsep.pepperdine.edu/~fmadjidi/To%20create%20a%20Pareto%20Chart.html
    Any problems email me at home at gawdzilla@aol.com and I’ll send you the link
       Have Fun.

    #36475
    Avatar of Alan Jephcott
    Alan Jephcott
    Participant
    Reputation - 0
    Rank - Aluminum

    An alternative process to produce a similar chart to Minitab would be as follows:
    Select (Note, if data analysis does not appera in the drop down list, first go to and select )
    Choose select your data ranges (discrete categories in one column, continuous data in the other) in the
    Check mark , , and
    Choose where you want the Output to go (pick a cell on existing worksheet, select a new worksheet ply or a new workbook.

    #36484

    I am not affiliated with this company, but I have used their product and it’s a snap. It’s called Pareto Pro and they give you a 15 day trial.Mark

Viewing 5 posts - 1 through 5 (of 5 total)

The forum ‘General’ is closed to new topics and replies.

Login Form