Look for the "Color by Category Label (Conditional Formatting)" section
way down near the bottom of my seminal pie chart article:
http://pubs.logicalexpressions.com/P...cle.asp?ID=390
Change the letter labels ("AAAA", "BBBB", etc.) to the product names,
and select your colors (trial and error, usually).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Co-op Bank wrote:
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