assign formating rules to charts?

[doug firr]

Hi. I create a large number of pie charts for my monthly reporting. I need alter the color of each segment of the chart according to the brand being measured. Rather than selecting each segment of every chart and choosing the color manually is there a quick way where I could either copy/paste the formating of one chart (tried doesn't work) and paste to another or is there a way to assign certain colors.

e.g.
brand one: red
brand 2: green
brand 3: blue

etc

anyone?

 

[doug firr]

Actually want to rephrase this question:

If I make the labels that are used for the pie chart certain colors is there a way to tell excel to make the corresponding segments the same color?