Custom Charts

You can save your chart including the layout and formatting as a custom chart type. You can then use the chart type when creating charts in the future.

Saving a chart as a custom chart type

• Select the chart
• Click Chart > Chart Type
• Click the Custom Types tab



• Click the User-defined option and then click Add
• The Add Custom Chart Type dialogue box is displayed

Enter a name and description for the chart and click Ok



The custom chart type has been saved and will be available the next time you create a chart.

Click the Set as default chart button to set the custom chart as the default style for creating new charts.

Create a new chart using a custom chart

1. Select the cell range to chart
2. Click the Chart Wizard button on the Standard toolbar



3. Click the Custom Types tab
4. Click the User-defined option
5. Select the Custom Type you wish to use
6. Complete any other necessary steps of the wizard and then click Finish

Delete a custom chart

Custom charts can be deleted when they are no longer needed.

1. Click Chart > Chart Type
2. Click the Custom Types tab
3. Click the User-defined option
4. Select the custom chart to be deleted
5. Click Delete
6. A message appears asking for confirmation to delete the user-defined format



7. Click Ok and then Ok again

Add a trendline Consolidating data

Guides