how do I keep my data series colour when I refresh a pivot chart

R

reghog

I changed the colours on the data series on my pivot chart but when I
refreshed the data it switched the colours back to the defaults. How can I
stop this?
 
Top