Creating a Chart with One Keystroke in Excel 2007:-

Previous versions of 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. Excel 2007 still recognizes that F11 shortcut, and it adds an Alt+F1 shortcut, which creates a default chart as a chart object embedded in the current worksheet. The Alt+F1 keystroke is a time saver when you need to create charts that match the Excel default. When Excel is installed, the default chart is a 2-D column chart. You can easily change the default chart type to best fit the type of charts you create the most. Here’s how:

1. Select an existing chart. In the Design ribbon, click the Change Chart Type icon. If you do not have an existing chart in your workbook, click the dialog launcher icon in the Charts group of the Insert ribbon.

2. Click the chart subtype that is closest to the chart type you want to create.

3. In the lower-left of the dialog, click Set as Default Chart. Then click Cancel to leave the dialog box.

After you go through this procedure, you can press F11 or Alt+F1 to create the selected chart type instead of the column chart.