OK Hek,
That's what I needed to know. I had to manually format 52 series because I couldn't
see any other way to do it...
A pain... but it's done now.
Thanks very much,
Al Camp

"HEK" wrote in message
...
Yes, that's the idea, Al. I haven't tested this at length, and I am not an
expert just a user myself. On quick testing with a line chart I found that
if you have more series than the ones defined in your custom-built, these
series will get the default format (5 point markers, the colours Excel uses,
etc). Less doesnt seem to be a problem. I suggest just to try it out and
see whether this suits you.
GL, Henk

"Al Camp" wrote:

Henk,
Thanks for the reply...
So I take it that I must "manually" format all the series on one chart with 3pt
black
dot, and THEN... I can use that as a formatting default for other charts?

Thanks,
Al Camp

"HEK" wrote in message
...
Hi Al:
You can format your chart in any way you like and store this as custom
chart. When you later choose this CustomChart with your data it will reflect
the appearance you defined. Make your chart, right click a series and choose
Chart Type... from the pop-up menu. Select the Custom Types tab, and select
User-defined in the "Select from" area. Choose a descriptive name and save,
and your format settings are ready for re-use.
Good luck,
Henk


"Al Camp" wrote:

Is there any way I can force a chart (scatter in this case) to always use a "3pt
black
dot" for all series that "may" develop.
My graph works fine, but every once in a while there are more series plotted than I
have
previously "manually" formatted. Those new series appear as a variety of shapes and
colors.
I'd like to make the graph "always use a 3pt black dot for ANY series."

Tried a Google Group search, but wasn't sure what terminology to use ("excel"
"default"
"series"), so I didn't get any relevant hits.

Thanks for any assistance,

Al Camp