Hello all,

My problem: Say I have my data in A1:G5 and a Line Chart with 5 lines for each row. Now I format my lines, say I want the first to be red, second yellow, etc. Now I sort my data largest to smallest based on column G and now, the highest G value will have the red line, the second the yellow, not those for which I formatted. I want the formatting to stick with the line even after sorting, not to stay static on the table.
This is important, because from time to time, I will add new data to the table, do the sorting based on new data, and want the colors to stay with the series I initially set.
So far I couldn't find any solution to begin with, thanks for your support in afvance.