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 .
About This Shortcut
This shortcut will a create a chart using data in current range on a separate worksheet. This is a very good way to quickly visualize data to check for patterns, outliers, or inconsistencies.