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](https://ask.pgcc.edu/TDPortal/Images/Viewer?fileName=9693fcc1-2a99-441a-a5a4-eb2e06fcb836.png)
Step 2
Click the Insert tab then click Recommended Charts.
![Title: Microsoft Excel; Description: Image of Recommended Charts option](https://ask.pgcc.edu/TDPortal/Images/Viewer?fileName=de1262aa-8b64-4476-b823-d564303fccff.png)
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](https://ask.pgcc.edu/TDPortal/Images/Viewer?fileName=0c34d471-9ee1-4c7a-9265-83c78a9f18fa.png)
The chart is inserted in your worksheet.
![Title: Microsoft Excel; Description: Image of Inserted Chart](https://ask.pgcc.edu/TDPortal/Images/Viewer?fileName=25f01edb-28d0-4ddf-a986-aebc32770d6e.png)