Sometimes the ‘Save as Template…’ option is greyed out with no explanation. However, there’s nothing stopping you saving a Chart Template. When you later come to use your template to create another chart, only templates saved in the default folder will appear as available for selection. Then just give the template a name that will enable you to identify it later, and save in the suggested location.įor Excel to quickly find the template save it to the default location and leave it there. To save your template, simply right-click on the completed chart and select Save as Template. Fortunately, you don’t have to because Excel allows you to save your chart as a template to use again whenever you need it.
Excel has a huge range of charts available and endless ways to customize them, but after working to get it just right, you don’t want to have to go through the whole process again next time you want to make a similar chart.
