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

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

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" wrote:

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

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/ChartsH...stomTypes.html

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


"Jess" wrote in message
...
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" wrote:

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