When I create a pivot bar chart there are preset default colours. I can
change the colours but when I refresh the data the colours change back to the
original ones. How do I keep the same colours?