Just select some data then go to Insert > Recommended Charts.
Excel will pop swing open the Insert Chart window and list recommended charts, each with a preview.
Excel’s recommended charts are meant to fit the data.
They’re based on professionally designed templates, and generally they look pretty good.
Notice when you use Recommended charts, the window has two tabs.
The first tab is “Recommended charts” and the second tab is “All charts”.
The All Charts tab allows you to see every chart option.
It also has links to recent charts and any saved chart templates.
Excel is generally very good at guessing the data you’d like want to chart.
So, you could usually just select a single cell in the data, then create the chart.
If you want to exclude data from the start, make a specific selection first.
If you have the Quick Analysis option enabled, you might also use this icon to create a chart.
Just select some data, then opt for icon, then select Charts.
Excel provides shortcuts for creating charts.
Both of these shortcuts will use the current default chart in Excel.
Now when I use Alt F1 to create a chart, the new default is used.
