If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do i create a user defined chart in Powerpoint or excel? | Magnus | Charts and Charting | 1 | December 7th, 2005 04:52 PM |
Create Excel Log automatically from Template | CaymanCarrie | Worksheet Functions | 0 | October 12th, 2005 04:40 PM |
How do I create a new Organization Chart wizard template in Visio. | tinkertoy | Visio | 1 | December 1st, 2004 05:39 PM |
Org Chart Template | Chris | Visio | 0 | July 28th, 2004 05:41 PM |
On opening a spreadsheet. | Pinda | Worksheet Functions | 7 | September 30th, 2003 09:36 PM |