See all Microsoft Excel tips
Strategy: You can create a chart with one keystroke! Select the data, ncluding theheadings and row labels, as shown in Fig. 1064.
Press the F11 key. The data is charted on a new chart sheet, as shown in Fig. 1065.
Caution: If your data includes dates as labels, the upper left corner cell of the data range should be blank. Do not include a heading such as “Date” there.
Additional Details: You can change the type of chart created with the single keystroke. While a chart is active, choose Chart – Chart Type. Select a Chart type and choose the button
for Set as Default Chart, as shown in Fig. 1066. All future one-click charts will be created as this type.
Summary: Create charts in a single click with the F11 key.
Commands Discussed: Chart – Chart Type – Set as Default Chart
See all Microsoft Excel tips