same options for multiple charts

J

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

Jon Peltier

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

- Jon
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top