Template?

[Lisa O]

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

 

[Gord Dibben]

Click on the formatted chart and Chart>Chart Type>Custom Types>User Defined>Add

Give it name and description and OK then hit "Set as default chart"


Gord Dibben MS Excel MVP