Pivot Tables – charts

When I produced a chart from a pivot table and customise the bar
colours etc, when I refresh it, it goes back to the default colours
(blue) I want different colours for each data bar from the pivot
table data set

Excel 2003

Thanks


Johnnyboy