ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can I create my own chart template in Excel? (https://www.excelbanter.com/charts-charting-excel/70925-can-i-create-my-own-chart-template-excel.html)

Matt

Can I create my own chart template in Excel?
 
I'm creating 20 or 30 charts in excel and I want them all to have the same
format. For example, I'd like the background a particular color, the fonts a
particular size, the scale from 0 to 100, etc....What I have been doing is
manually making the individual adjustments to each chart, but I think there
must be a way that I can do it for one chart and do a "apply template" or
something for the remaining charts. I searched through the help menu but
couldn't find how to do this.

Any help would be greatly appreciated!

Matt

David Welch

Can I create my own chart template in Excel?
 
Copy your template chart, select other charts and goto
Edit-PasteSpecial and choose Formats

Matt wrote:
I'm creating 20 or 30 charts in excel and I want them all to have the same
format. For example, I'd like the background a particular color, the fonts a
particular size, the scale from 0 to 100, etc....What I have been doing is
manually making the individual adjustments to each chart, but I think there
must be a way that I can do it for one chart and do a "apply template" or
something for the remaining charts. I searched through the help menu but
couldn't find how to do this.

Any help would be greatly appreciated!

Matt


Matt

Can I create my own chart template in Excel?
 
That was easy. Sometimes the easiest answer is right in front of you.

Thanks!

"David Welch" wrote:

Copy your template chart, select other charts and goto
Edit-PasteSpecial and choose Formats

Matt wrote:
I'm creating 20 or 30 charts in excel and I want them all to have the same
format. For example, I'd like the background a particular color, the fonts a
particular size, the scale from 0 to 100, etc....What I have been doing is
manually making the individual adjustments to each chart, but I think there
must be a way that I can do it for one chart and do a "apply template" or
something for the remaining charts. I searched through the help menu but
couldn't find how to do this.

Any help would be greatly appreciated!

Matt




All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com