Recommended PivotTables and Recommended Charts In Excel

Try this feature when you're unsure on which PivotTable or chart to use.

Thomas Duff

by Thomas Duff on 8/1/2016

Share this:

Article Details

Date Revised:

Applies to:
Excel, Excel charts, Excel PivotTable

PivotTables and Charts are very useful in turning a large amount of Excel data into meaningful information that can be easily understood. But you might not have a clear idea as to what PivotTable or chart would be best for the data you have.

In Excel 2013, you can now let Excel recommend the best way to show the data. 

With your spreadsheet open, go to the Insert tab and click Recommended PivotTables or Recommended Charts:

Sample Excel data

In my test spreadsheet, I have test data with names, dates, company, city, and other various data. When I click on Recommended PivotTables, I get a number of options that would make sense for this type of data:

Recommended Excel PivotTable choices

Likewise, clicking on Recommended Charts gives me some potential ideas for how I could chart this data:

Recommended Excel chart choices

When you click on the selected item and click OK, Excel will add that PivotTable or chart to your spreadsheet.

Topic: One Minute Office Magic

Sign in with

Or register