what is the shortcut key for graphs

how to open directly different types of graphs in excel

1 Answer(s)


1) To insert a chart on a new worksheet-
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.