Microsoft Excel: How To Use the Recommended Charts Feature

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.

Title: Microsoft Excel; Description: Image of Selected Data

Step 2

Click the Insert tab then click Recommended Charts.

Title: Microsoft Excel; Description: Image of Recommended Charts option

The Recommended Charts will be displayed.

Step 3

Choose the chart you wish to use then click OK.

Title: Microsoft Excel; Description: Image of Insert Chart dialog with Recommended Charts displayed

The chart is inserted in your worksheet.

Title: Microsoft Excel; Description: Image of Inserted Chart

Print Article