A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can I create my own chart template in Excel?



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2006, 03:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 10th, 2006, 05:24 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 10th, 2006, 05:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:36 PM.


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