This is a discussion on Macro to assign series colors to line chart? within the Excel Questions forums, part of the Question Forums category; Hello there I regularly create line graphs using data for the same set of series, and I want consistency across ...
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.
oranges = orange
apples = red
blueberries = blue
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!