Using Shortcut keys to create a Chart

Excel 365 2013 2010 2007 2003
Excel proposes an easy and very fast way to create a chart by using shortcut keys.

Excel allowed you to create a chart by selecting the data and pressing the F11 key. In response, Excel created a default chart on a new sheet.

For example, if you have data like this:

Data Range in Excel 2016

Only select the data range and press F11:

Chart by Shortcut keys in Excel 2016

You can also use the Alt+F1 shortcut, which creates a default chart as a chart object embedded in the current worksheet. See more How to change default chart.

In Excel 2016 you can create a chart via the Quick Analysis Tool - then you select the chart data, you will see the Quick Analysis feature (see more How to turn on/off the Quick Analysis Feature):

Quick Analysis in Excel 2016

Here you can choose which kind of chart should be created.

See also this tip in French: Raccourcis pour créer un graphique.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.