Create Excel Chart With Shortcut Keys

To create a chart in Excel, you can select the data on the worksheet, then use the Ribbon commands to insert the chart.

chartkeyboard01

Use the Keyboard Shortcuts

If you’d rather use the keyboard to insert a chart, there are a couple of shortcut keys that you can tap.

To insert a new sheet in the workbook, with a chart for the selected data, you can press the F11 key.

chartkeyboard02

To insert the chart on the active worksheet, use the Alt + F1 shortcut keys

chartkeyboard03

Change the Default Chart Type

When you create a chart using the keyboard shortcuts, the default chart type is used. To select a different default chart type:

On the Excel Ribbon, click the Insert tab

In the Charts group, click the Dialog Launcher button, at the bottom right

chartkeyboard04

Select one of the chart types, and a Sub-type, then click Set as Default Chart

chartkeyboard05

Click Cancel, to close the window.

Then, when you create new charts with one of the keyboard shortcuts, the new default type will be used.

Watch the Chart Shortcut Keys Video

To see the steps for creating an Excel chart with a keyboard shortcut, watch this short Excel tutorial video.

Or watch on YouTube: Create Excel Chart with Shortcut Keys

_________

You may also like...

5 Responses

  1. Pawan Kuldip Kerketta says:

    Hey,

    I liked it. Its cool.

    Rgds,
    Pawan

  2. Andrew says:

    Clear and concise, just what I was looking for!

  3. Soahil says:

    thanks it Really time saving in Stock Analysis chart with in seconds.

    Thanks again.

  4. chethan kumar says:

    Thank you for giving nice information

  5. dhaemendra yadav says:

    nice information…..,

Leave a Reply

Your email address will not be published. Required fields are marked *