Unwanted color changes in column chart series

[Rob Miller]

This seems to be a new behavior in Excel 2010 and 2013.

I have a table of various data points for 4 subsets of a market. In the past, I would create the graphs (usually combo column/line) for the first subset and get them to my liking. Then I would copy and paste those graphs 3 times, and change the data being graphed for each.

Now when I do this, the colors of the bars and lines CHANGE (!?). Dear Excel, this is NOT helpful. It is the opposite of helpful. Why does the program assume I want to go back to whatever it defaults to?

Is there a resolution? Is there a new way of working that I need to undertake? Please help.

Best regards,
Rob

 

[Hui]

Bizarre, I've never seen that happen ?

You could save the first chart as a template and then apply that template to the other charts

To save a Chart as a Template

• Select the base Chart
• Goto Chart Tools, Design, Save as Template

To Apply a Template

• Select the Destination chart
• Goto Chart Tools, Design, Change Chart Type
• Select Templates
• Select the Template you want to use