Let Excel Recommend the Best Chart

Thursday, November 5, 2015

Picking the right chart for your data can be tough.

Should it be a pie chart? A column chart? Or a bar chart?

Let Excel do the hard work for you.

Excel's Recommended Chart feature will recommend the best charts for your data.

It's easy to let Excel show you the best charts for your data.

Here's how to do it in Microsoft Excel 2013 and 2016:

1. Select a cell in the range of data you want to see as a chart.
2. On the ribbon bar, select the "Insert Tab".
3. Click "Recommended Charts".