Hello there
I regularly create line graphs using data for the same set of series, and I want consistency across my graphs in terms of each series always being represented by the same color.
e.g.
oranges = orange
apples = red
blueberries = blue
...etc

Excel applies the default colors according to the order the series appear in the source data, and I have to go in and manually change the color of every line.

Does anyone know if it is possible (and how to) write a macro so that I can just select the chart or data, run the macro, and have each series always be the same color? This would save me SO much time!

...thanks!