Forum Discussion

Halteres's avatar
Halteres
Copper Contributor
Nov 30, 2020

Chart templates in Excel

The menu option for "Save As Template" is easily seen with a right-click on a chart. However, the reverse procedure is not evident. How is a saved template applied to a chart?
Charting
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 30, 2020
Right-click the chart, choose Change Chart Type, click "Templates " in the category list and choose your template.
  • Halteres's avatar
    Halteres
    Copper Contributor
    Nov 30, 2020

    JKPieterse Thank you for your reply. This procedure was followed, with no result. The template is not applied to the chart. Screenshots of the results have been taken, in order of pressing "OK". The screenshots can't be attached because the "Upload" button on this web forum page is not working.

    • JonPeltierMVP's avatar
      JonPeltierMVP
      Iron Contributor
      Dec 01, 2020

      Halteres Could you upload your screenshots to a file sharing site, like imgur.com?

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Dec 01, 2020
      Odd indeed!
      • Halteres's avatar
        Halteres
        Copper Contributor
        Dec 01, 2020

        JKPieterse The German language pack was removed : no difference. Office 365 was completely removed, and reinstalled : just the same. Also, the formatting that was applied to one chart to make the template in the first place has disappeared, along with some data on other worksheets in the workbook, so I have to start again. It's too much to put up with in a subscription to professional software. Disappearing data has occurred before, and no resolution was ever found.

Resources