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
Copying Backgrounds, Bar Colors, etc. from Chart to Chart 1
How to make scroll bar permanently visible, Word 365 0
Why do charts disappear? 3
Repeating colors in excel 2007 area charts 3
How do I migrate Outlook 2007 to Outlook 2019? 0
how to change color gradients in a bar chart 0
sideways stacked bar charts with line series on the same axis 0

Top