Creating Custom Chart Formats

There may be times when the built-in chart formats just don't meet your needs. In these instances, you can always make any changes desired to your chart and then save all the chart settings as a user-defined format. You can then apply these settings to other charts, and you won't have to go through the long or tedious steps necessary to do all the formatting over again.

To create your own chart format, follow these steps:

1. Use whatever formatting commands are necessary to define your chart just the way you want it.
2. Choose Chart Type from the Chart menu. Excel displays the Chart Type dialog box.
3. Make sure the Custom Types tab is displayed. (Click here to see a related figure.)
4. Make sure the User-defined option button is selected at the bottom of the dialog box.
5. Click on the Add button. Excel displays the Add Custom Chart Type dialog box. (Click here to see a related figure.)
6. Enter the name and description that you want assigned to this chart format.
7. Click on OK. The format is saved and is available from the Custom tab of the Chart Types dialog box.