Sort pivot chart columns dynamically by quantity

[vavs]

I have a pivot table that I am using to create a bar chart. The filter for the table is based on city. There are four columns with an integer value in each. The bar chart shows the four values as the value fields in each column. What I would like to do is show the largest value first and have the chart step down with the next largest value until all values are used. The problem is that the largest value is going to change with each change in the city. Is there a way to force the chart to be sorted largest to smallest?

 

[pbornemeier]

Please post a minimal subset of your data and explain how your pivot table is arranged. It may be possible.