The recommended charts button was added in Excel 2013.
The charts are good looking and in most cases they fit the data pretty well.
This list represents the chart types Excel recommends, based on the data you’ve selected.
Notice the Insert Chart 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 available, not just recommended charts.
It also has links to recent charts and any saved chart templates.
This will save you a little time.
Like Recommended Charts, these buttons also provide live previews.
When you hover over an icon, Excel will build a preview directly on the worksheet below.
Just click to insert the chart.
You’ll see exactly this same behavior if you tap the Change chart punch in button directly.
opt for data, then punch in: Alt + N + R
