Pie Chart Slice Colours Help??

[stephen.smith]

Hi Guys I need to change the slice colours in numerous pie charts as quickly as possible. I have about 200 pie charts and for some reason all charts have the same colour for each slice but i need them to be different colours for each slice. Is there a way to do this quickly and easily??

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=577229

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).