audiate
Board Regular
- Joined
- Jun 20, 2003
- Messages
- 79
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!
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!