Share Custom Chart Types in MS Excel
To save your active Microsoft Office Excel chart as a template that you can reuse or share, on the Chart Tools Design tab, in the Type section, click Save as Template. In the Save Chart Template dialog box, type a name for your new chart type, and then click Save.
To create a chart based on a chart template, on the Insert tab, at the bottom-right corner of the Charts section, click the dialog box launch icon to open the Insert Chart dialog box. Then click Templates to access your saved custom chart types. Each chart template is saved as an individual file that you can copy and share.
Saved chart templates are located in your Microsoft Office user templates folder, inside a subfolder named Charts. To locate your user templates folder, click the Office button, and then click Excel Options. Click the Trust Center tab, and then click Trust Center Settings. 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.