{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pareto Chart with Data","Pareto Chart1"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Pareto Chart1","index":1,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pareto Chart with Data","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,0,15,1]]}
["Problem Area","Occurrences",0,{"$f":"SUM(B2:B12)","v":179}]
["Defect 1",41,{"$f":"C1 + B2/$D$1","v":0.22905027932960895}]
["Defect 2",35,{"$f":"C2 + B3/$D$1","v":0.42458100558659218}]
["Defect 3",25,{"$f":"C3 + B4/$D$1","v":0.56424581005586594}]
["Defect 4",21,0.68156424581005592]
["Defect 5",18,0.78212290502793302]
["Defect 6",12,0.84916201117318446]
["Defect 7",10,0.9050279329608939]
["Defect 8",7,0.94413407821229056]
["Defect 9",5,0.97206703910614534]
["Defect 10",3,0.98882681564245822]
["Defect 11",2,1.0000000000000002]
[]
[]
[]
["Instructions"]
["1. Input your labels and data in A2:B12"]
["2. Highlight your data  A1:B12"]
["3. In the standard toolbar, click on Data"]
["4. Click on sort"]
["5. Sort by occurrences descending"]
["6. Press OK"]