1) To insert a chart on a new worksheet-
Apr 27 2014 07:49 PM
Simply select any cell on your data and press the F11 key. The chart will be created on the new sheet.
2) To insert a chart on the same worksheet
Select the data and press ALT+F1 key.
This is for column charts because it is the default chart-type.
To set another chart as the default chart-type, go to INSERT Tab, and under Charts group, select any other chart-type say for example, Pie and click on 'Set as Default Chart'. Press OK.