title: Sort pie chart's slices without sorting the data in the columns
body: <p>I haven't found something similar to that on the web, and it seems that the only way for the data to be sorted on the pie chart is if they're pre-sorted.
  The problem is that I have a sheet populated by a third party software (Typeform) that places random data, which I then aggregate to present to the pie chart.</p>
  
  <p>More specifically, Typeform writes </p>
  
  <pre><code> town   | salary | cost
  London  | 1000   | 500
  Bristol | 700    | 300
  London  | 900    | 400
  Leeds   | 600    | 200
  Leeds   | 500    | 300
  Leeds   | 400    | 200
  </code></pre>
  
  <p>Then I aggregate the data in another sheet (Sheet2) so that I have</p>
  
  <pre><code>town   |  occurrences
  London      2
  Bristol     1
  Leeds       3
  </code></pre>
  
  <p>Obviously the pie chart will draw London first, then Bristol, and then Leeds. These are only 3 entries, however in my example, I have 20, and the data in the pie chart are not ordered.</p>
  
  <p>Sheet2's data cannot be sorted descending since I am using <code>=UNIQUE(Sheet1!A2:A)</code> and then in the column next to it <code>=countif(Sheet1!A:A,A2)</code> to populate them from the Sheet1 where the 3rd party software is writing them, in fact when I select them and click sort they don't get sorted, they reappear as they were.</p>
  
  <p>Is there any way to sort them (and keep them sorted) in Sheet2, or by writing them in a new sheet?</p>