Add a Quick Chart to Your Worksheet or Workbook
The quick chart keyboard shortcut adds a commonly used chart to the current worksheet or to a separate worksheet in the current workbook. Here’s how to add a new chart to a new worksheet in an existing workbook: A chart is created and added to a separate worksheet in the current workbook. If the default settings haven’t been changed, a column chart is created by pressing F11. As well as adding a copy of the chart to a separate worksheet, that same chart can be added to the current worksheet by using different keyboard shortcut keys. Here’s how to add a chart to the same worksheet:
Change the Chart Type
If pressing F11 or Alt+F1 produces a chart that isn’t to your liking, change the chart with the help of built-in templates. Here’s how to change the chart type:
Create and Save Chart Templates
If you want use a predefined chart style, create a chart that uses the chart style, colors, scale settings, and font type you want. Then, save the chart as a template. Follow these steps to save your new chart template:
Delete a Chart Template
If you don’t need a chart template you created, delete it to remove it from your list of templates in Excel. To delete a chart template:
