Hi

In my job I have to make lots of charts using excel, usually bar charts. What I’ve noticed is that sometimes if I copy and paste a chart and then change the data, the colours will remain the same, and other times it will change. Can anybody explain this? It would save me a lot of time if I could me if I could fix it to retain the colors every time.

Special paste, keep format doesn’t work, and setting the workbook themes doesn’t help because I need to make charts with different themes in the same workbook.

So can anybody help me with one of the following:

1)Making pasted charts retain their colors when changing the underlying data
2)Perhaps making themes operate on a single page
3)Making personalized themes available to apply to a single chart. Why wouldn’t this option be available readily?

Thanks in advance for any and all help advice given.