Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting up default font size in comments | Setting up and Configuration of Excel | |||
Has anyone had problems setting the font size for a title through VBA? | Charts and Charting in Excel | |||
custom paper size setting | New Users to Excel | |||
comment setting defaults | Excel Discussion (Misc queries) | |||
setting a floating decimel point | New Users to Excel |