Can I change the default syle for a chart?

[Guest]

I have toyed around with using macros to reformat data, but what I would
really like to do is make a particular format the default, but can't seem to
find out how to do that.

 

[Debra Dalgleish]

Select a chart in your workbook
Choose Chart>Chart Type

Select one of the chart types and subtypes, then click
'Set as default chart'
OR
Select the Custom Types tab, and set one of the built-in or
user-defined charts as the default

Jon Peltier has information on custom chart types on his web site:

http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html