How do I duplicate background, bar colors, etc. to other charts?

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.
 
S

Shane Devenshire

Hi,

Save the customized chart as a template and then apply that to the other
charts:

1. Chart Tools, Design, Save As Template...
2. with another chart selected choose Chart Tools, Design, Change Chart
Type, Templates ...
 

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

Similar Threads

How do I duplicate background, bar color, etc. to other Charts? 3
Repeating colors in excel 2007 area charts 3
Change background for ALL charts without custom defining all chart 4
Is there a 'format painter' equivalent to use on many charts? 2
Why do charts disappear? 2
How to create multiple bar charts at the same time? 0
Conditional colors for bars in a chart??? 7
Charts made in excel 2003 won't print to the correct size in 2007? 1

Top