Template?

  • Thread starter Thread starter Lisa O
  • Start date Start date
L

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
 
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
 
Back
Top