Thread: setting defaults for data point size, color, shadow, etc.

I make a lot of Excel XY (Scatter) charts. Every time, the charts get created with the same set of colors, sizes, and shadowing of the markers (the dots in the plot), and it happens that I don't like these colors, sizes, and shadowings. So each time I make a plot, I go through and change these things to settings that I like. Is there a way for me to reset the default settings so that these charts are automatically made with the settings that I like?

Thanks.

Make chart as needed and select it (click on it)
Use command Chart | Chart Type
Select Custom tab and then User-Defined
Click Add ... the rest is self-evident
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"EJF" <EJF.241emm_1141294203.5541@excelforum-nospam.com> wrote in message
news:EJF.241emm_1141294203.5541@excelforum-nospam.com...
>
> I make a lot of Excel XY (Scatter) charts. Every time, the charts get
> created with the same set of colors, sizes, and shadowing of the
> markers (the dots in the plot), and it happens that I don't like these
> colors, sizes, and shadowings. So each time I make a plot, I go through
> and change these things to settings that I like. Is there a way for me
> to reset the default settings so that these charts are automatically
> made with the settings that I like?
>
> Thanks.
>
>
> --
> EJF
> ------------------------------------------------------------------------
> EJF's Profile:
> http://www.excelforum.com/member.php...o&userid=32065
> View this thread: http://www.excelforum.com/showthread...hreadid=518159
>

Thank you so much. You've just saved me a ton of time!

Best wishes,

Eric

You most welcome!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"EJF" <EJF.242361_1141326015.1312@excelforum-nospam.com> wrote in message
news:EJF.242361_1141326015.1312@excelforum-nospam.com...
>
> Thank you so much. You've just saved me a ton of time!
>
> Best wishes,
>
> Eric
>
>
> --
> EJF
> ------------------------------------------------------------------------
> EJF's Profile:
> http://www.excelforum.com/member.php...o&userid=32065
> View this thread: http://www.excelforum.com/showthread...hreadid=518159
>