Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I duplicate background, bar color, etc. to other Charts? BWeech Excel Discussion (Misc queries) 3 June 21st 09 04:01 AM
Can you alternate background colors by gridline? Mikey Charts and Charting in Excel 1 April 1st 08 06:13 PM
functions with background colors Marcelo Excel Worksheet Functions 4 December 10th 07 07:53 PM
Lost highlighting and font colors; background colors on web pages Jan in Raleigh Excel Discussion (Misc queries) 2 July 31st 07 09:10 PM
Alternate Background-colors sissi Excel Discussion (Misc queries) 1 August 21st 06 04:16 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"