Hi,

I want to change the formatting imposed by default in a pivot chart and I
want that changed formatting to be retained permanently.

For example, for my bar chart, for the different series I have selected
colours / patterns but every time I refresh the pivot table / chart; excel
falls back to its own colour coding.

Any way to get around this?

Many thanks in anticipation.