Colors of columns after sorting data in the supporting table
When creating a chart off of a table, the colors of each column appear to be
in the order of their display in the chart. For example, let's say I have
January data as red, February data as white and March data as blue. Then I
sort the table in the Excel sheet by value. Now the labels are ordered
February, March, January. Well, now the first column (February) is red, the
second (March) white and the third (January)blue.
Is there a method to hard-code the column color to the data label in the
charts rather than simply the order that the data appears?