Where is pivot in excel 2010

When you use this feature, Excel determines a meaningful layout by matching the data with the most suitable areas in the PivotTable. This helps give you a starting point for additional experimentation. After a recommended PivotTable is created, you can explore different orientations and rearrange fields to achieve your specific results.

You can also download our interactive Make your first PivotTable tutorial. Excel analyzes your data and presents you with several options, like in this example using the household expense data.

Select the PivotTable that looks best to you and press OK. Excel will display the Create PivotTable dialog with your range or table name selected. For Existing Worksheet , select the cell where you want the PivotTable placed. In the Field Name area at the top, select the check box for any field you want to add to your PivotTable. By default, non-numeric fields are added to the Row area, date and time fields are added to the Column area, and numeric fields are added to the Values area.

You can also manually drag-and-drop any available item into any of the PivotTable fields, or if you no longer want an item in your PivotTable, simply drag it out of the Fields list or uncheck it. Being able to rearrange Field items is one of the PivotTable features that makes it so easy to quickly change its appearance. This is why it's so important to make sure you don't mix data types for value fields. You can change the default calculation by first clicking on the arrow to the right of the field name, then select the Field Settings option.

Next, change the calculation in the Summarize by section. Note that when you change the calculation method, Excel will automatically append it in the Custom Name section, like "Sum of FieldName", but you can change it.

If you click the Number Tip: Since the changing the calculation in the Summarize by section will change the PivotTable field name, it's best not to rename your PivotTable fields until you're done setting up your PivotTable. Instead of using a calculation to summarize the data, you can also display it as a percentage of a field. Once you've opened the Field Settings dialog, you can make your selections from the Show data as tab. Display a value as both a calculation and percentage.

Simply drag the item into the Values section twice, right-click the value and select Field Settings , then set the Summarize by and Show data as options for each one. If you add new data to your PivotTable data source, any PivotTables that were built on that data source need to be refreshed. To refresh just one PivotTable you can right-click anywhere in the PivotTable range, then select Refresh. If you created a PivotTable and decide you no longer want it, you can simply select the entire PivotTable range, then press Delete.

It won't have any affect on other data or PivotTables or charts around it. If your PivotTable is on a separate sheet that has no other data you want to keep, deleting that sheet is a fast way to remove the PivotTable.

Note: We're constantly working to improve PivotTables in Excel for the web. New changes are being rolled out gradually, so if the steps in this article may not exactly match your experience.

All updates will roll out eventually. You can either manually create your own PivotTable or choose a recommended PivotTable that was created for you. Do one of the following:. Note: Recommended PivotTables are only available to Microsoft subscribers.

If needed, you can change the Source for the PivotTable data before you create one. Download Example. Before we get started, we first want to show you the data for the pivot table. In this example, the data is found on Sheet1. Highlight the cell where you'd like to see the pivot table. In this example, we've selected cell A1 on Sheet2. Next, select the Insert tab from the toolbar at the top of the screen.

In the Tables group , click on the arrow under the PivotTable button and select PivotTable from the popup menu. Then, just go to the familiar Data menu, you will find the Pivot Table function listed in the drop down menu. Without Classic Menu for Excel installed, it is not so intuitive to get this function. If you do need to use PivotChart Wizard, there still are several ways to configure it.

Brings the familiar classic menus and toolbars back to Microsoft Office , , , , and