Windows Mac
AltF1 Fn⌥F1

About This Shortcut 

This shortcut will create and insert a chart using data in current range as an embedded object in the current worksheet.

Note: the Mac shortcut does not seem to be working on current versions of OS X and Excel 2011. One reason might be that Option + F1 activates Display Preferences. However, this shortcut does not appear under System Preferences > Keyboard > Keyboard Shortcuts so it's not clear how to disable it and also not certain that disabling it would solve the problem.

Do you know a workaround? Let us know.

Related videos

Excel Use a throwaway chart to sanity check data

Use a throwaway chart to sanity check data

In this video, we'll look at how to use a throwaway chart to explore data. In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick disposable chart is a great way to check and explore data. For example, in this worksheet, I have some sample …
Excel Ways to create a chart

Ways to create a chart

In this video, we'll look at several different ways you can create charts in Excel. In later versions of Excel, starting with Excel 2013, the best option for creating a new chart is usually the Recommended Charts button on the Insert tab of the ribbon. Just select some data then go to Insert > …
Excel Shortcuts for charts

Shortcuts for charts

You can change the default chart type by opening the Chart Type control on the ribbon, selecting a chart type, and clicking the set default button. This setting controls the default for all new charts in all workbooks. Note that hen you just randomly select cell in a set of data, Excel will try to …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.