Dynamic column chart - auto sort on data range
 

I have a column/bar chart that updates every day using defined names. It
shows the last 30 days of data summed together in one bar for 23 different
machines. The first column of the data is the date; the first row is the
machine discription. I want the data to auto sort in the row whenever it is
updated. This will in turn sort my column chart from high to low.
Can anyone help?