Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Matt
 
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   Report Post  
Posted to microsoft.public.excel.charting
David Welch
 
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   Report Post  
Posted to microsoft.public.excel.charting
Matt
 
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do i create a user defined chart in Powerpoint or excel? Magnus Charts and Charting in Excel 1 December 7th 05 04:52 PM
Using Microsoft Excel Chart object in VB6 fizbim Charts and Charting in Excel 0 July 13th 05 05:14 PM
Bond Yield Template with Payment schecule and chart (Excel) Jen Excel Discussion (Misc queries) 3 April 28th 05 08:18 PM
Adding a chart to a Word template linked to an Excel doc. Bobbie Excel Discussion (Misc queries) 0 January 3rd 05 08:07 PM


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"