Do you find yourself re-creating charts in Excel or copy-pasting the same old chart and then having to delete all of the old data each time you need to make a new chart? If so, I have the quick and dirty solution for you: Chart Templates. This is a simple task that will save you loads of time and effort in the future! You can then reuse and even share your template with others. Here's how you can save your active Excel chart as a template:

1. On the Chart Tools Design tab, under the Type section -> Click Save as Template
   
2. In the Save Chart Template dialog box -> Type a name for your new chart type -> Click Save
   

That's all folks! You are all done creating your template. Now to the even better part: How to create a chart based on the template:

1. On the Insert tab in the lower-right corner of the Charts section -> Click the dialog box launch icon to open the Insert Chart dialog box
   
2. Click Templates to access your saved custom chart types
   [FYI: Each chart template is saved as an individual file that you can copy and share]
   

Also, FYI: Saved chart templates are located in your Microsoft Office User Templates folder, inside a sub-folder named Charts.

To locate your User Templates folder:

1. Click the Office button -> Click Excel Options
   
2. Click the Trust Center tab -> Click Trust Center Settings
   
3. In the Trust Center dialog box, on the Trusted Locations tab -> Double-Click the entry Excel 2007 default location: User Templates to view the full file path