Recommended PivotTables and Recommended Charts In Excel

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-20160801-1

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-pivottables-20160801-2

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

recommended-excel-charts-20160801-3

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s