ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I duplicate background, bar colors, etc. to other charts? (https://www.excelbanter.com/charts-charting-excel/234491-how-do-i-duplicate-background-bar-colors-etc-other-charts.html)

BWeech

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

Shane Devenshire[_2_]

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