Exceljet

Quick, clean, and to the point

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.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
Use a throwaway chart to sanity check data
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.
Ways to create a chart
In this video, we'll look at several different ways you can create charts in Excel, including the recommended charts option.
Shortcuts for charts
In this lesson, we cover shortcuts you can use when working with Excel charts.
How to customize a category axis
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.