![]() |
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 |
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 |
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