The Recommended Charts feature shows you which charts work best based on your data.
This knowledge article demonstrates how to use the Recommended Charts feature in Microsoft Excel 2016.
Step 1
Select your data. Note: In order to view the Recommended Charts, you must first select your data.

Step 2
Click the Insert tab then click Recommended Charts.

The Recommended Charts will be displayed.
Step 3
Choose the chart you wish to use then click OK.

The chart is inserted in your worksheet.
