Nov 30 2020 07:04 AM
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?
Nov 30 2020 07:37 AM
Nov 30 2020 08:38 AM
@Jan Karel Pieterse 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.
Dec 01 2020 03:53 AM
@Jan Karel Pieterse 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.
Dec 01 2020 07:23 AM
Dec 01 2020 07:47 AM
Thank you for your reply. Would you please point me to a resolution? A large number of charts need formatting.
Dec 01 2020 08:37 AM
@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.
Dec 01 2020 08:51 AM
@Halteres Could you upload your screenshots to a file sharing site, like imgur.com?