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.

Related videos

Tip: Use a throwaway chart to sanity check data
In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick, messy chart is a great way to "sanity check" unfamiliar data. A chart can show you patterns and outliers almost instantly. It can even show when data has been faked. Best of all, you get all of this with almost no effort.
You have saved me HOURS of work. Thank you so much!!!! - Jennifer
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course