Quick, clean, and to the point

Create chart in new worksheet

Windows shortcut 
Mac shortcut 

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.

I also wanted to tell you in researching this formula problem, I combed through about 50 videos and websites. Yours was the most professional, easy to understand, and welcoming to a student who wishes to become more knowledgeable with Excel. -Devorah
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course