The default line colours in Excel 2013 charts have poor contrast and are not easily distinguishable. I would like to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I get the Excel 2003 chart themes and defaults into Excel 2013 (without a lot of work and learning on my part - am a retired engineer and not very computer literate).
The Chart Tools ► Design ► Type ► Save as Template command found in Excel 2007/2010 has been removed from the ribbon and allocated to the right-click menu available when your chart (not a chart element) is selected. Likewise, the Set as Default Chart command from the Change Chart Type dialog has been replaced with a Recommended Charts tab on 2013's Insert Chart or Change Chart Type dialog.
Create (or reopen) a chart with your desired formatting. Right-click the body of the chart and choose
Save as Template... to make a template copy in your
%APPDATA%\Microsoft\Templates\Charts folder. The new chart template will be available for future Insert ► Chart commands.
Excel 2016: The approach is similar. 1) select the chart that you have modified to make you happy. 2) right mouse-click on the chart to get a menu. 3) select "Save as Template..." and give the template a name in the pop-up.
4) Make a new chart. 5) select the chart and right mouse-click 6) select "change chart type ..." 7) there is a folder "templates" Your template is saved here. Click on it and you are done.