Creating a Chart Template¶

When you first create a chart in Excel, the chart that appears is Microsoft’s default design.  To quickly change the design, the Chart Template is the answer. After creating your chart, highlight it and select the template to change to your preferred design.

1. Click on a Price Bulletin chart that has the correct formatting.

2. Select the Design menu on the Excel ribbon

3. Select Save Template and give your template a name (e.g., PB 20000 to show that the X-axis reaches a maximum of 20000)

4. When you need to recreate the same chart design, click on the chart requiring this new design.

5. Select the Design menu on the Excel ribbon

6. Select Change Chart Type, click on the new design in the Templates list, and click OK.  Adjust the x-axis if needed.