I have a worksheet of 444 rows, each of which has two columns containing sparklines. I want to sort the data by keys in another two columns. I select the whole worksheet, then Home>Sort and filter>Custom sort> select the column containing the key I want to sort by>Return. All the columns except those containing the sparklines sort correctly. The sparklines are of different colours and different max Y-axis values. After sorting, the sparklines retain the colour of the original row, and sometimes the original Y-axis value, rather than the correct new colour and value. Can anyone help?