Format one chart the way you like it, copy the chart, select the next chart,
go to Edit menu Paste Special, and choose Formats.

Note, this will also copy such things as the chart title and customized
label text.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"moily" wrote in message
...
Hello I have a bit of a problem - I have over 100 pie charts that need to
have their colour scheme changed so that they can be seen against a dark
blue
background. Is it possible to do this quickly or do I have to change each
segment of each chart individually? Is it even possible to choose all the
indivdual colours for the segments while the graph is being created?
Basically, any changes en masse is what I'm looking for. TIA