Formatting to stay with sorted data in Line Chart

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.

If you use conditional formatting so that the colours are generated by means of a formula based on a cell's contents, then the colours would follow the data even after sorting.

Hope this helps.

Pete

Hello,

Thanks for the answer, I'm talking about formatting the lines of the Line Chart, and setting those lines' colors, not the fill of the cells themselves.
Can conditional formatting somehow be applied to the lines of a graph?

Any ideas?

Thanks for the tip, i dont think i couldve solved it with that, but somehow it gave me an idea to make a "copy" where the lines are kept in order with vlookup from the original, no matter how i sort those, so i get what i whant, thx everyone