Yes, that can be very frustrating. Unfortunately, XL essentially 'redraws'
the entire chart. I don't know of any way to retain original information
other than to have a macro redo the format the way you want after XL finishes
doing its stuff. Of course, you can always do the same by hand and that is
something I do if the amount of work is not very much or it's something I do
infrequently.
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"Scott" wrote:

If I make a copy of a chart (line type with 20 sets of data), it will look
just like the original. If I change the source data in the copy all 20 lines
change color. Why is this and how can I prevent it?