77-881 · Question #113
Mark the option button in the following image of the Design tab to save a chart's formatting to provide a standard layout and uniform format across multiple charts.
The Save as Template button on the Design tab is used to save the format and layout of a chart. Take the following steps to save a chart as a chart template: 1.Click the chart that you want to save as a template. The Chart Tools tab is displayed containing the Design, Layout…
Question
Explanation
The Save as Template button on the Design tab is used to save the format and layout of a chart. Take the following steps to save a chart as a chart template: 1.Click the chart that you want to save as a template. The Chart Tools tab is displayed containing the Design, Layout, and Format tabs. 2.Click on the Design tab, and click Save as Template in the Type group. 3.The Save Chart Template dialog box opens. In the File name box, type a name for the template. Click the Save button.
Topics
Community Discussion
7
Imani T.Jun 26, 2026The correct answer is the Save As Template button on the Chart Tools Design tab. That button is specifically designed to capture all of your chart formatting into a reusable .crtx template file, which you can then apply to other charts to keep everything looking consistent without redoing the work each time.
Bao N.Jun 26, 2026That question is missing its answer options, so which button are you circling, Save as Template?
Hiroshi T.Jun 26, 2026The correct button is Save as Template, located in the Type group on the Chart Tools Design tab. Microsoft's official documentation for Office 2010 confirms that clicking Save as Template writes a .crtx file to the Charts template folder, which you can then apply to any subsequent chart to enforce the same formatting and layout.
Brenda K.Jun 28, 2026Hiroshi nailed it on the .crtx file, but worth noting that if your Charts template folder path is ever pointing somewhere unexpected, you can confirm or redirect it via Excel Options, Save, so your templates actually show up under My Templates when you go to insert a chart.
Brenda K.Jun 26, 2026That button is Change Chart Type, no question. You click it, set everything up the way you want, and that dialog is where the template logic lives, because saving a layout means locking in the chart type itself as the foundation. The whole point of a uniform format across charts starts with type consistency, and that is the button doing that work on the Design tab.
Bao N.Jun 29, 2026That is solid but worth noting the actual sequence matters too, because if you set your data range first and then open Change Chart Type to swap formats, you can lose axis mappings and end up re-doing that configuration from scratch.
Anjali D.Jun 26, 2026Save As Template, not "Save Chart" which trips a lot of people up.