title: Sorting data on google sheets chart
body: <p>I have unsorted data in the sheet and I would like to show a chart with sorted data.</p>
  <p>Here is an example:</p>
  <p><a href="https://i.stack.imgur.com/8b2mN.png" rel="noreferrer"><img src="https://i.stack.imgur.com/8b2mN.png" alt="enter image description here" /></a></p>
  <hr />
  <p>I would like the chart to be sorted ascending, by compensation.</p>
  <p>How can this be done with the data being structured as on the picture?</p>