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...
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.