Create, share, or delete your own chart types

Microsoft Excel provides a variety of standard and built-in custom chart types. If needed, however, you can turn any chart type that you have modified when you created a chart into a user-defined custom chart type that you can use again or share with other users.

 Note   All custom chart types are available in workbooks. Built-in custom chart types are stored in Xl8galry.xls. Any user-defined custom chart types that you create are stored in Xlusrgal.xls.

  1. Do one of the following:
  2. On the Chart menu, click Chart Type.
  3. On the Custom Types tab, under Select from, click User-defined.
  4. Do one of the following:
    • To add a custom chart type, click Add, and then type a name in the Name box.
      If you want to add a description, type it in the Description box.
    • To delete a custom chart type, click it in the Chart Type box, and then click Delete.

 Note   You cannot delete a built-in custom chart type.

  1. Click OK.

 Note   You can choose a custom chart type when you want to create another chart. User-defined custom chart types are available in the Chart wizard on the Custom Types tab under Select from User-defined. For information on how to create a chart, see Create a chart.

 Tip   You can share any user-defined custom chart type with other users. For example, if you want the same title information to appear on all of your company charts, you can create a chart that has that title, save that chart as a custom chart type, and then share it with others so that they can use the custom chart type as a template. When other users open a copy of the workbook that contains the custom chart type on their computers, they can make the custom chart type available for use in other workbooks by following the steps in the procedure above for adding a custom chart type.

Applies to:
Excel 2003