Hello,

I am going to create about 20 or so pie charts which break down sales for a
particular region. Each pie will show the same products (about 5 in total
Interest, non interest etc) and I wondered if there is a way to assign a
segment colour to a product.
So for example all segments on all pie charts for 'Interest' are blue.
I presume this may need to be a VBA solution? Any assistance much appreciated.
Many thanks

Brian
Co-op Bank
Manchester, England