- Spreadsheets To Practice Pivot Tables
- How To Do A Pivot Table In Excel For Mac
- Excel Pivot Table Tutorial Pdf
This Excel tutorial explains how to change the data source for a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions).
Spreadsheets To Practice Pivot Tables
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?
Answer:Click somewhere in the pivot table and the PivotTable tab should appear in the toolbar at the top of the screen. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu.
When the Change PivotTable Data Source window appears, change the Location value to reflect the new data source for your pivot table. Click on the OK button.
By default, a Pivot Table will count all records in a data set. To show a unique or distinct count in a pivot table, you must add data to the object model when the pivot table is created. In the example shown, the pivot table displays how many unique colors are sold in each state. The pivot table shown is based on two fields: State. In Excel, when you create a pivot table, the row labels are displayed as a compact layout, all the headings are listed in one column. Sometimes, you need to convert the compact layout to outline form to make the table more clearly. But in tphe outline layout, the headings will be displayed at the top of the group.
How To Do A Pivot Table In Excel For Mac
Excel Pivot Table Tutorial Pdf
Now when you return to your pivot table, it should display information from the new data source.