Copying Backgrounds, Bar Colors, etc. from Chart to Chart

B

BWeech

I have 11 charts in one Workbook that tall need to have the same backgrounds,
bar colors, fonts, etc. How can I customize one and then duplicate the
customization on the other 10? I'm running Excel 2007.
 
B

Beth Melton

Select one of your formatted charts and on the contextual Design tab, click
"Save as Template" (do not change the default file location). Then after
it's saved to use it on other charts, use the "Change Chart Type" command
and you'll find your newly created chart template in the Templates folder at
the top of the dialog box.

~Beth Melton
Microsoft Office MVP
 
Top