Last answered:

27 Feb 2023

Posted on:

26 Feb 2023

0

Task 7 Pareto Line % is wrong

I made this chart in the web version of Excel but the percentages are wrong and I don't know how to change it. For some strange reason, it starts at a strangely high percent and decreases as the line increases. How can I correct the percent?

2 answers ( 0 marked as helpful)
Instructor
Posted on:

27 Feb 2023

0

Hi Dylan, 

thanks for reaching out! Could you also share a screenshot of the columns you used to create the chart? And any formula's you may have used in any of the columns

Thanks in advance! 


Best, 

365 Eli

Posted on:

27 Feb 2023

0

Hi Eli,


I think this is what you mean? If not let me know. Using the USA row as an example the formulas are =COUNTIF('365RE'!$V$6:$V$201,'Tasks 6,7'!C11) for the Frequency column, =D11/$D$19 for the Relative Frequency column, and =E11 for the Cumulative Frequency column. Clicking the Pareto Diagram shows me this information.

Submit an answer