Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do i create a user defined chart in Powerpoint or excel? | Charts and Charting in Excel | |||
Using Microsoft Excel Chart object in VB6 | Charts and Charting in Excel | |||
Bond Yield Template with Payment schecule and chart (Excel) | Excel Discussion (Misc queries) | |||
Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) |