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

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