Can't create a chart template

Copper Contributor

On a worksheet, I've entered data and used it to create 2 charts. I want to create chart templates so I can reuse the chart styles elsewhere. I was able to create a template for one of the charts, and reuse it. However, for the second chart, when I right-click the chart, the "Save as template" option is grayed out. I can't figure out how to make it active. Any advice?

PattyG_0-1657035717150.png

 

1 Reply

@PattyG A co-worker pointed out this information. This must be the case here. :(
"Sometimes the ‘Save as Template…’ option is greyed out with no explanation.

Newer chart types, added with Excel 365 cannot be saved as templates. This limitation is true for all the new chart types released in Office 2016/365 like Waterfall, Histogram, Treemap, etc.

Amazingly, these charts were added to Excel without including template support.  Microsoft considers templates an ‘extra’ that they’ll consider adding if there’s enough customer interest.  Despite the passing of several years, this hasn’t happened."
Source: https://office-watch.com/2019/saving-an-excel-chart-as-a-template/