Hi,

I have a spreadsheet that has a list of lights and their power ratings, amougst other data.

In the first 5 columns, I have information about which light it is, and in the last two columns I have information about the power of the light.

I want to make a pareto chart of the power rating of the light and the name of that light, but I do not want to alter the data around such that the list of lights is ordered by their power rating, which is demonstrated in a few online tutorials of how to make a pareto chart, the list currently is ordered by it's location, which is what I want to retain.