ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   setting defaults for data point size, color, shadow, etc. (https://www.excelbanter.com/charts-charting-excel/74818-setting-defaults-data-point-size-color-shadow-etc.html)

EJF

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.


--
EJF
------------------------------------------------------------------------
EJF's Profile: http://www.excelforum.com/member.php...o&userid=32065
View this thread: http://www.excelforum.com/showthread...hreadid=518159


Bernard Liengme

setting defaults for data point size, color, shadow, etc.
 
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" wrote in message
...

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




EJF

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

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


Bernard Liengme

setting defaults for data point size, color, shadow, etc.
 
You most welcome!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"EJF" wrote in message
...

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





All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com