Forum Discussion
Reset Color Order for Visible Lines
I am working with a line plot, where for instance I would like to plot the earnings of an employee. We have many stores and many employees, so I filter down by store name and then employee. The issue...
I don't believe this works for a couple reasons. 1) conditional formatting is not available for line plots 2)once I add a legend (for a column chart) conditional formatting is no longer available.
The legend applies the colors currently, so maybe I could re-word the question:
If I am setting distinct lines by legend, is there a way to order the colors based on the order in the legend. For example, if my legend has 5 entries, regardless of what the store and employee are, make the first entry colored blue, the second colored red, etc.