Create chart in new worksheet
Windows shortcut
F11
Mac shortcut
FnF11
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.
Related videos
The videos below demonstrate this shortcut.
In this video, we'll look at how to use a "throwaway" chart to explore data. This is an easy way to quickly size up data.
In this video, we'll look at several different ways you can create charts in Excel, including the recommended charts option.
In this video, we'll look at options for customizing a category axis in an Excel chart.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.