Creating a Chart with a Custom Template

Charts

When you want to create a chart using one of the templates you’ve previously created with your choice of chart type and format, follow these steps.

If you want to use the default custom template that you previously assigned, select the data as you normally would, and press Alt+F1 to create a chart on the same worksheet or press F11 to create a chart in a chartsheet.

If you want to create a chart using one of the non-default custom templates then,

  1. Select the data.
  2. On the Insert tab, in the Charts group, select Other Charts, then All Chart Types.
  3. In the Insert Charts dialog box, select the Template button and choose the template you want for the new chart.
  4. Click Ok.

If you have an existing chart and you want to apply a template to it then,

  1. Right-click the chart and select Change Chart Type.
  2. Select the Template button and choose the template you want for the new chart.
  3. Click Ok.

 

Share the power...