Sorting Columns in a Query?

[Coolboy55]

I have a query that returns a varying number of columns and one value per column, which is a sum. I would like to sort the columns based on the value returned for that column.

The end goal is to create a pareto chart from this data. If it is possible to sort columns in the chart itself, that would be fine too.

[Mariostg]

Maybe not what you want, but why don't you bring you data into XL and use the analysis tool pack to make your pareto chart.
Select Tools>Data Analysis>Histor gam. In options, select Pareto.