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