View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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