Pie chart colors

[kari713]

How do you assign certain colors to a specific value in a pie chart? For example, I need January to be blue and February to be Red and so on

 

[Andrew Poulsom]

If the data you are plotting is always in the same order you can just modify the Chart fill colours under Tools|Options|Color tab. The colour palette is saved with the workbook.

 

[kari713]

I should have used a different example instead of months because the data will usually be in a different order...I figure i'll probably need some type of macro