![]() |
How do I duplicate background, bar colors, etc. to other charts?
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. -- BWeech |
How do I duplicate background, bar colors, etc. to other charts?
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 ... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "BWeech" wrote: 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. -- BWeech |
All times are GMT +1. The time now is 01:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com