Creating charts with keyboard shortcut

Select range of cells and data and click F11. It will create a chart from your default chart settings on a separate sheet. To create a chart on the same page use shortcut Alt+F1. To change the default chart type click the Insert tab, open Insert Chart dialog, choose type of chart you would like and click the Set as Default option. Now when you use the F11 or Alt+F1 shortcuts you will notice that the type of chart has now changed to your default selection.