Change default marker type - Excel 2007

[Niels]

I have to make a large number of scatter graphs with the markers as filled,
round, black circles. I there a way to change the default marker type to a
build-in circle, black, size 4, no border. Thanks for any suggestions,

Niels

 

[John Mansfield]

You can create a user-defined chart as a template that contains all of your
custom settings. To do so, first create the chart that you want. In Excel
2003, go to

Chart -> Chart Type -> Custom Types -> User-Defined -> Add

Select a name for your chart. Your custom chart will now be saved for
future use.

 

[karl]

John could I use this in Excel 2000 to change the markers to numbers