Hello Excel gods, I come to your mountain seeking wisdom.

I have a bar chart with 12 categories that are referenced from a data table,
and that data is filterd from 3 drop downs. I have the chart set up now that
the chart data and graphics update as the drop downs are changed, but my boss
(aka. the man) wants the chart to display largest to smallest absolute
values. I can do all of that but what I don't know how to achieve is to make
it autosort descending just by me changing the drop down menu. Is there a way
to default the data table to automatically sort each time the drop down is
changed?