Graph Query

[stephen.smith]

Hey Guys
I have created a number of worksheets which all contain about ten pie charts of information. On The Original Page the Pie Charts has all the info flowing in different colours for each different element however on all of the subsequent pages all elements display the same colour. Is there an easy way to format all of the graphs on all worksheets collectively or do I have to format each individual graph in isolation.
Thanks
Stephen

 

[stephen.smith]

Hi Guys the wording above was not very clear. Here is what I am looking to do, 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??