Assigning colors based on chart value
Is there a way to assign charts colors based on a value in the data set, for example instead of colors being assigned based on the order they are in the series they are based on a value. If i have several products i want the product to always have the same color no matter where it falls in the order of the series based on…