Hi all,
I am attempting to apply a consistent color scheme across bar graphs, each corresponding to a small table, all contained within the same sheet. I understand how to change the bar colors individually, and can apply a standard color scheme across SERIES, but have been unable to easily create a new graph for each corresponding data set that automatically applies a different color (but the same scheme in each graph) to each different CATEGORY value within the the graph.
I have tried changing the colors manually and saving that the chart as a template, but the color formatting doesn't load when I insert to the template to apply it to the new data set. Nor does it load the color scheme when I copy and paste each graph itself next to a new table, and then select the new table's data.
Each small table that I am attempting to graph (each contains 1 column of percent values for approximately 2-5 possibly survey responses) is in the same worksheet, with graphs next to each one in the same sheet). I am graphing hundreds of these, so I would prefer to avoid having to manipulate any of the data in the tables themselves, if avoidable.
Any suggestions you have are very much appreciated.
Thanks!
Bookmarks