View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jess Jess is offline
external usenet poster
 
Posts: 60
Default same options for multiple charts

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