F11 is the correct keyboard shortcut to create a chart in Microsoft Excel. When you have data selected, pressing F11 instantly creates a new chart sheet with a default chart. The other options (F10, F12, F4) perform different functions like activating menu bar, saving as, or repeating last action.