I notice that automatic line colours for series on x-y plots don't match the series order if series are added or deleted from a chart. The line colours seem to follow the order in which the series were originally inserted on the chart, not the order in which they are plotted. Does anybody know a way of resetting the automatic colours to be consistent with the plot order? For example, if I plot six series on a chart, then duplicate the chart and delete the first three series from the original and the second three series from the copy, the automatic colours on both charts remain as for the original six series; I want them to reset to the first three automatic colours for both charts so that series 1 has the same colour on both charts. Also, if I insert several series on a chart then change their order, the series names in the legend change order but the line colours do not. This comes up so often in the work I do it makes consistent formatting of charts time consuming (without using VBA).