peltiertech.com
A Linked Table to Sort Data for Charting - Peltier Tech Blog
I am often asked how to sort the data in a table without sorting the original data. The answer is twofold: the chart’s source data has to be sorted for the charted data to be sorted, but you don’t have to sort the original data if you can write a few formulas. The trick is …