How to Create a Chart in Excel Using Keyboard Shortcuts

Whether you need a chart quickly or want to monitor certain trends in your data, create a chart in Excel with a single keystroke. Excel has a default table that is activated using keyboard shortcuts. If you find this feature useful, you can adapt the different templates to suit your future needs.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010, 2007; Excel for Mac and Excel for Office 365.

Contents
  1. Add a quick chart to your worksheet or workbook
  2. Change chart type
  3. Create and save chart templates
  4. Delete chart template

Add a quick chart to your worksheet or workbook

The Shortcut Map shortcut adds a frequently used chart to the current worksheet or to an individual worksheet in the current workbook.

To add a new chart to a new worksheet and to an existing workbook:

  1. Select the data you want to use in the chart.

  2. Press key F11 on keyboard.

The chart is created and added to a separate sheet in the current workbook. If the default settings have not been changed, a bar graph is created by pressing the F11 key.

Mac users may need to hold down a key fn by pressing a function key such as F1. Also, some functions, such as F11, may not work unless macOS hotkeys, such as expose, are disabled first.

In addition to adding a copy of a chart to a separate worksheet, the same chart can be added to the current worksheet, the worksheet that contains the chart data, using various keyboard shortcuts.

To add a chart to the same worksheet, do the following:

  1. Select the data you want to use in the chart.

  2. Press and hold a key alt † If you are using a Mac, replace the Alt key with the Option

  3. Press key F1

Now a new chart is created and added to your current worksheet along with your data.

Change chart type

If you create a chart you don’t like by pressing F11 or Alt+F1, modify the chart using the built-in templates.

You can change the chart type as follows:

  1. Select a schedule.

  2. Open a tab Chart Tools Design

  3. Select Change chart type

  4. Select the chart type you want to use.

  5. Choose a chart style.

  6. Click Okay when you’re done.

Create and save chart templates

To use a predefined chart style, create a chart that uses the chart style, colors, scale settings, and the desired font. Then save the chart as a template.

To save your new card template, complete the following steps:

  1. Right click on the chart to open the context menu.

  2. Select Save as template to open the Save Chart Template dialog box.

  3. Enter a name for the template in the File name text box.

  4. Select Save to save the template and close the dialog box.

The map template file is saved as a .crtx file in C:Documents and Settingsusername>AppDataRoamingMicrosoftTemplatesCharts.

Delete chart template

If you don’t need the chart template you created, delete it to remove it from the list of templates in Excel.

To delete a chart template:

  1. Open a tab Chart Tools Design

  2. Select Change chart type to open the Change Chart Type dialog box.

  3. Select Templates to see a list of card templates.

  4. Select Template management to open a file explorer with saved card templates.

  5. Right click on the chart template you want to delete and select remove

Leave a Reply

Your email address will not be published.