

Go to the Insert tab and click “Recommended Charts” in the Charts section of the ribbon. RELATED: How to Create and Customize a Pareto Chart in Microsoft Excel Select the data for the chart as you normally would to create any new chart. When you want to use a template you’ve saved, this is also super simple. Give your template a name and click “Save.” Now your template is saved and ready for you to reuse. Right-click the chart and select “Save as Template.” RELATED: How to Create and Customize a Waterfall Chart in Microsoft Excel Whether you already have a chart or graph you want to save or are planning to save the next chart you create, it’s easy enough.

RELATED: How to Save Time with Excel Themes Save a Chart as a Template Best of all, you can use a chart template in any Excel workbook and sheet once you save it. Plus, you can hang onto those company colors or specific formatting you spent so much time applying. So, if you create a chart and want to reuse the colors and formatting, save it as a template!īy turning your hard work into a reusable template, you can save time later. Creating a chart in Microsoft Excel is a reasonably simple process, but it’s the customizations you apply that take the most time.
