Preventing chart colours to change when source data is changed - Excel 2003

[ankita.sethi]

Hi,

When I change the source data of a chart, the chart colours change automatically. Can anyone suggest how can this be prevented?

(If the solution is in VBA, it is more than welcome)

Thanks,
Ankita