Automatically Sort a Pivot Table After Filter

Yes that's correct, apologies I should have been more clear in my description.

However the challenge remains the same, although the chart is reading from the additional data, if I could auto sort the pivot table to always be from largest to smallest then the additional data would do the same and the chart would display the largest to smallest.

Is there a way to sort the pivot table automatically after the filter has been applied, at the moment I have to select the pivot table and then sort, I don't want users having to do this.

If its not possible, would you have any suggestion of an alternative way?

Much appreciated, Cheers,
Charles