![]() |
Template?
I have created a sheet that lists 12 months of information and for each month
I have to create a chart. After creating the first chart, I formatted everything - color, shading, font, etc. the way I wanted it to look. Is there a way that I can make all of my charts auto-format to look like my first one, or do I have to go and adjust everything for each chart every time? I have been trying for awhile after reading everything under my "help" info and can't get it to work. Someone tell me please that this has GOT to be something simple!! :) I am working on Excel2003 -- Lisa |
Template?
Click on the formatted chart and ChartChart TypeCustom TypesUser DefinedAdd
Give it name and description and OK then hit "Set as default chart" Gord Dibben MS Excel MVP On Fri, 18 Jul 2008 13:51:02 -0700, Lisa O wrote: I have created a sheet that lists 12 months of information and for each month I have to create a chart. After creating the first chart, I formatted everything - color, shading, font, etc. the way I wanted it to look. Is there a way that I can make all of my charts auto-format to look like my first one, or do I have to go and adjust everything for each chart every time? I have been trying for awhile after reading everything under my "help" info and can't get it to work. Someone tell me please that this has GOT to be something simple!! :) I am working on Excel2003 |
All times are GMT +1. The time now is 06:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com