Recommended Charts and Pivot Tables

Excel 2013 incudes template charts and pivot tables which are provided by the Recommended Charts and Recommended Pivot Table features. The available options are provided intelligently based on the selected data.

Click into or select the data to be pivoted. On the Insert tab, select Recommended Pivot Tables. The dialog box then previews pivot tables suitable from the based on the structure of the data.

Choose the required table layout and click OK. The pivot table will be created on a new sheet.

Recommended charts work in the same way.

Click into or select the data to be pivoted. On the Insert tab, select Recommended Charts. The dialog box then previews charts suitable for the structure of the data.

One thought on “Recommended Charts and Pivot Tables

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s