Select Save as Template… You’ll save a file with a CRTX extension in your default Microsoft Excel Templates folder.
To create a new chart based on the template:
Select the data you want to chart.
Click the Insert tab / Recommended Charts, the All Charts tab, and the Templates folder.
In the My Templates box, pick the one to apply, then click OK. Some elements, like the actual text in the legends and titles, won’t translate unless they’re part of the data selected. However, all fonts, colors, graphics and series options will be applied to the new chart.
Comments
Save an Excel Chart as a Template — 1 Comment
This was so helpful! Exactly what i was looking for. Thank you!
This was so helpful! Exactly what i was looking for. Thank you!