In 2013 and later versions, you will need to click on the All Charts tab to see Templates. Now, when you want to apply it, click the dialog box launcher on the in the Charts group on the Insert tab and choose Templates.This will make it easier to locate it when you want to apply it to a new chart.

crtx file to save at its default location.

In Excel 2013 and later: Right-click on the chart itself and choose Save as Template.

In Excel 2010 and earlier: On the Design tab, click the second button from the left, Save as Template.

So you can practice this skill in the exercise file, change the color of a data series to a different color you’ll recognize in a new chart. Keep in mind that you may select a single series or single data point (column, bar, pie wedge, etc.) and format it as you would any other shape, choosing a specific color, rather than relying on the active theme to choose it for you. In Excel 2013 and later, access the Chart Elements tool by selecting your chart and clicking the plus sign icon to the upper right of the chart area. NOTE: In Excel 2010 and prior, use the Design tab. Excel will automatically select the rest of the data when you insert your chart. NOTE: If your data is contiguous (no blank rows or columns), click into one cell in the chart data.

Select the data you wish to chart and press F11, to create a chart in the default style on its own worksheet, or click the Insert tab and choose your starting chart type.

Here’s how.ĭownload Excelchartsgraphstemplates.xlsx and work along. Who wants to keep doing that over and over?! You can create a template for each customized chart and graph you have and do all that hard work in a couple of clicks.

But if you’re a frequent user of the charts feature in Excel, you may spend quite a bit of time getting the colors, appearance and elements of a chart just right. We might not normally think of creating templates for Excel charts and graphs. By Melissa Esquibel Categories: Charts, Excel® Tags: excel graphs templates

Dialog box launcher excel 2013