- Click the chart you want to save as a custom chart type.
- On the Chart menu, click Chart Type.
- On the Custom Types tab, click User-defined.
- Click Add.
- In the Name box, type a name.
- If you want to add a description, type it in the Description box.
- Click OK.
Share a custom chart type with other users
- On each user's machine, open the copy of the workbook that contains the custom chart type you want to share.
- Click the chart you want to save as a custom chart type.
- On the Chart menu, click Chart Type.
- On the Custom Types tab, click User-defined.
- Click Add.
- In the Name box, type a name.
- If you want to add a description, type it in the Description box.
- Click OK.
Delete a user-defined custom chart type
- To activate the Chart menu, click a chart.
- On the Chart menu, click Chart Type.
- On the Custom Types tab, click User-defined.
- In the Chart type box, click the format you want to delete.
- Click Delete, and then click OK.
Note You cannot delete a built-in custom chart type.