When I copy a chart I get two identical ones. When I change the values of one
of the charts and sort the values, Excel changes the colors of the categories
to a preset order, so that the color of the biggest customer in chart 1 is
not the same as this same customer (let's say now on the third place) in
chart 2.
Is there a way to prevent this?