I have created a pivot chart and then changed the series colours but when i
refresh the data the colours revert back to their original colour. How can I
stop this please?