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
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.
