Hi,

I have created a pivot chart. I change the color of the bar from the default
to what I want. However, when i change the selection, ie instead of choosing
singapore, i choose Hong Kong, the bar color return back to the default
color. Anyway I can fix it to what I want.

Kindly advise.