same options for multiple charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jess - 28 Nov 2006 18:07 GMT

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

Reply to this Message

Jon Peltier - 28 Nov 2006 18:27 GMT

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
_______

>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
[quoted text clipped - 10 lines]
>
> PLEASE HELP! Thanks!!

Reply to this Message

Jess - 28 Nov 2006 19:09 GMT

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.

> What kind of options? What changes about the data or chart that cause colors
> to be inconsistent?
[quoted text clipped - 20 lines]
> >
> > PLEASE HELP! Thanks!!

Reply to this Message

Jon Peltier - 29 Nov 2006 04:46 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

>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
[quoted text clipped - 35 lines]
>> >
>> > PLEASE HELP! Thanks!!

Reply to this Message