Forum Discussion
Ranking data and creating a pareto chart with duplicate values
Hello, Does anyone know how to overcome issues with ranking duplicate values in a data set when trying to generate a pareto chart? I have attached an example of the data set I am working with...
The values in column C refer to another workbook, so we see #VALUE!
Thank you for letting me know Hans, I have amended and uploaded the file again
In the attached version, I added tiny random disturbances to the data. I left the column of random numbers that I used for your information, but it is not needed any more. The disturbances break the ties.
They are hidden by formatting the numbers with 0 decimal places.
Bethany1993 Why bother ranking? Perhaps you can work with a solution like in the attached workbook.
