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
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.

JKPieterse's avatar
JKPieterse
Silver Contributor
Dec 01, 2020
Odd, I've never had issues like these before and I've been using Office for over two decades.
  • Halteres's avatar
    Halteres
    Copper Contributor
    Dec 01, 2020

    Thank you for your reply. Would you please point me to a resolution? A large number of charts need formatting. 

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Dec 01, 2020

      Halteres Some suggestions I got from a colleague:

       

      "I wonder if his chart template has only one data series formatted, so the others are not appearing. For example, if he’s changing from a column chart to a one-series bar or stacked bar, it may be that the 2nd series is appearing as white against the white sheet background. It could be all kinds of things, but difficult to pinpoint without seeing the CRTX.

       

      Also, it’s weird that the formatting from the original source chart has disappeared, and the CRTX wouldn’t affect the data in the other worksheets. Maybe he’s got a corrupt workbook? Or maybe he needs to reboot. (And why would he think the German language pack would be affecting it?)

       

      I might suggest that he reboot and try this using some dummy data in a new blank workbook – that is, paste in some data, create a chart, apply some formatting, save it as a chart template. Create a few other charts and apply the chart template. Does it work?

       

      Wonder if he’d be better off pasting formats?"

       

      Hope this gets you somewhere.

Resources