Re: Colors of columns after sorting data in the supporting table

The chart contains 12 series instead of 1 and the values within each series are controlled via worksheet formula. Only 1 value from each series is actual displayed.

The original data can then be sorted and the x axis labels and the column values will alter. But the colour associated with each month will remain constant. 

This workbook contains an example.