Using shortcut keys to create a chart

Excel 365 2016 2010 2007 2003
Excel propose 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 a data like this:

Data Range in Excel 2013

Only select the data range and press F11:

Chart by Shortcut keys in Excel 2013

You can use also 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 2013 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 2013

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

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