same options for multiple charts

[Jess]

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!!

 

[Jon Peltier]

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

- Jon

 

[Jess]

I keep track of monthly sales for 8 sales reps. Each slice of pie is color
coded per rep. I have to individually go in and change the colors of the pie
and the formatting options to get October's pie to look like the rest of
them, November's pie, December's pie, etc. I guess i'm looking for a way to
make it simplier rather than doing all the formatting each month when i add a
new pie chart.

 

[Jon Peltier]

Are the reps always in the same order? Then the problem is that the default
colors aren't right. Make a custom user-defined chart type based on one of
the existing charts:

http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

- Jon