Since you have a version of Excel which has Power Query built in (aka Get & Transform Data) the attached contains a second table created with Power Query which does the same as your sorting and this new table is plotted (twice; once with a true xy scatter plot, and the other a line plot (you can't do a true xy scatter plot from a pivot table)).
If your raw data in columns A & B change, you can update the new table by right-clicking somewhere within it and choosing Refresh.
Incidentally there's also a formula-only approach in cell O2.
|