Related topics
×
Create a PivotTable and analyze your data
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Create a PivotTable and analyze your data

Create a PivotTable

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Learn what a PivotTable and PivotCharts are, and how you can use them to summarize and analyze data in Excel 2013.

Create a PivotTable to analyze worksheet data

Being able to analyze all the data in your worksheet can help you make better business decisions. But sometimes it is hard to know where to start, especially when you have a lot of data.

Excel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data.

  1. Make sure your data has column headings or table headers, and that there are no blank rows.

  2. Click any cell in the range of cells or table.

  3. Click INSERT > Recommended PivotTables.

  4. In the Recommended PivotTables dialog box, click any PivotTable layout to get a preview, and then pick the one that shows the data the way you want, and click OK.

Create a PivotChart

A PivotChart can help you make sense of PivotTable data. While a PivotChart shows data series, categories, and chart axes the same way a standard chart does, it also gives you interactive filtering controls right on the chart, so you can quickly analyze a subset of your data.

  1. Click anywhere in the data.

  2. On the INSERT tab, in the Charts group, pick Recommended Charts.

  3. On the Recommended Charts tab, pick any chart with the PivotChart icon in the top corner. A preview of your PivotChart appears in the preview pane.

  4. Once you find the PivotChart you like, click OK. If you donโ€™t find a PivotChart you like, click PivotChart on the INSERT tab, instead of Recommended Charts.

  5. In the PivotChart, click any interactive control, and then pick the sort or filtering options you want.

Want more?

Create a PivotTable to analyze external data

Create a PivotTable to analyze data in multiple tables

Show different calculations in PivotTable value fields

Create a PivotChart

Available chart types

PivotTable reports are a powerful way to summarize, analyze, explore, and present your data in a report.

PivotTables can help you make sense of your data, especially when you have a lot of it.

This table has 800 rows. Click any cell in your data.

Click INSERT and Recommended PivotTables.

Excel recommends PivotTable layouts that'll work well with your data.

To help you decide, pick each of the recommendations to see what your data will look like in the preview box.

Sum of Order Amount by Salesperson is what I want, so I click OK.

Excel creates the PivotTable on a new worksheet.

The PivotTable Fields List appears to the right; we'll cover that in the Create a PivotTable report manually video.

I'm going to zoom in a little, to make the PivotTable easier to read.

Right-click any cell in the Sum of Order Amount column.

Click Number Format, pick Currency, and click OK.

And the numbers in the column are formatted as currency.

Up next: Create a PivotTable report manually.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×