Software & Apps MS Office How to Create a Chart in Excel Using Shortcut Keys Quickly add, modify, or delete a chart by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on January 14, 2020 The Ultimate Guide to Keyboard Shortcuts The Ultimate Guide to Keyboard Shortcuts Introduction Windows Timesavers The Best Windows 10 Keyboard Shortcuts Essential Keyboard Shortcuts for Better Productivity How to Use the Shortcut Alt + Underline Shortcut to Create New Folders Essential Shortcuts for iTunes Mac, iOS & iPad Quick Tricks The Best Mac Shortcuts Keyboard Shortcuts for Finder Mac Startup Keyboard Shortcuts 18 Shortcuts for Apple's iOS Shortcuts App iPad Keyboard Tips and Smart Keyboard Shortcuts Android & iPhone Shortcuts The Best Android Shortcuts You Should Be Using Create and Use iPhone X Shortcuts Email Shortcuts The 30 Best Gmail Keyboard Shortcuts for 2020 How to Use Yahoo Mail Keyboard Shortcuts The Complete Apple Mail Shortcut List Shortcuts in iOS Mail Delete Shortcut Keys for Popular Email Programs How to Use Outlook.com Keyboard Shortcuts Create Text Snippets With Shortcuts in Mac OS X Mail Online & Browser Shortcuts Top 36 Shortcuts for Edge and IE 11 Keyboard Shortcuts: Google Chrome for Windows Create Web Page Shortcuts in Chrome for Windows Control Safari Windows With Keyboard Shortcuts Shortcuts for Safari Toolbars Shortcuts for Safari on OS X & Sierra Excel Shortcuts The 23 Best Excel Shortcuts Shortcut Excel's Fill Down Command Shortcut the Current Date/Time Formatting Numbers Adding Worksheets Shortcut to Saving Your Work Creating a Chart MAX Function Shortcut More Office Shortcuts Top 10 Microsoft Word Shortcuts The 5 Best Hidden Word Shortcuts Add Shortcut Keys to AutoText Entries Uppercase Shortcut Key How to Reset Keyboard Shortcuts in Word Shortcut to Speed Up PowerPoint Presentations Other Useful Shortcuts The Best Google Docs Shortcuts 18 Shortcuts for Linux Mint 18 Cinnamon Changing Linux Mint Cinnamon Shortcuts Fedora GNOME Keyboard Shortcuts Maya Keyboard Shortcuts Create or Reassign Keyboard Shortcuts in MS Office Useful Keyboard Shortcuts for Photoshop CC Time-Saving Fill Tool Shortcuts in Photoshop The 5 Most Useful GIMP Keyboard Shortcuts How to Use the GIMP Keyboard Shortcut Editor Shortcuts to Type a Tilde Mark Westend61 / Getty Images Tweet Share Email When you need a chart in a hurry or want to check on certain trends in your data, create a chart in Microsoft Excel with a single keystroke. Excel has a default chart that's activated using keyboard shortcut keys. If you find the function useful, customize different templates to better suit your needs in the future. Instructions in this article apply to Excel 2019, 2016, 2013, 2010, 2007; Excel for Mac; and Excel for Microsoft 365. 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: Select the data you want to use in the chart. Press the F11 key on your keyboard. 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. Mac users may need to hold down the Fn key while pressing any function keys, such as F1. Additionally, some functions, such as F11, may not work unless macOS hotkeys, such as Expose, are first disabled. 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: Select the data you want to use in the chart. Press and hold the Alt key. If you are on a Mac, substitute the Option key. Press the F1 key. A new chart is created and added to your current worksheet, alongside your data. 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: Select the chart. Select the Chart Tools Design tab. Select Change Chart Type. Select the type of chart you'd like to use. Select the style of the chart. Select OK when you're done. 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: Right-click on the chart to open a context menu. Choose Save as Template to open the Save Chart Template dialog box. Enter a name for the template in the File name text box. Select Save to save the template and close the dialog box. The chart template file is saved as a .crtx file in the C:\Documents and Settings\<username>\AppData\Roaming\Microsoft\Templates\Charts folder. 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: Select the Chart Tools Design tab. Select Change Chart Type to open the Change Chart Type dialog box. Select Templates to see a list of your chart templates. Select Mange Templates to open the file manager showing the saved chart templates. Right-click on the chart template you want to delete and select Delete.