What kind of options? What changes about the data or chart that cause colors
to be inconsistent?

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


"Jess" wrote in message
...
I have monthly pie charts which are in separate sheets that are updated at
the end of the month. I would like each pie slice to maintain consistency
with color throughout the months. How do I go about having the same
options
for every single pie chart I create without having to invidiviually go in
and
change each chart every month?

I also have a YTD pie chart which I would like to be updated every time I
add data to the new month's chart. Is there a way this can be
automatically
updated?

PLEASE HELP! Thanks!!