Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.

Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements …

In Excel, you can pivot data in a PivotTable or PivotChart by changing the field layout of the data. By using the PivotTable Field List, you can add, rearrange, or remove fields to show data in a …

Sorting data is helpful when you have large amounts of data in a PivotTable or PivotChart. You can sort in alphabetical order, from highest to lowest values, or from lowest to highest values.

In a PivotTable or PivotChart, you can expand or collapse to any level of data detail, and even for all levels of detail in one operation. On Windows and the Mac, you can also expand or …

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Advanced date filters appear for row and column labels in a PivotTable or PivotChart when you add a field from the date table to the Row Labels or Column Labels of the Power Pivot field list.

Charts and PivotChart reports are vital tools for data analysis in Excel workbooks. Visual information makes it easier for you to see comparisons, patterns, and trends in data. You can …

Here's how you build a new PivotTable or PivotChart using the Data Model in your workbook. Click Open, and then click OK to show a Field List containing all the tables in the Data Model.

To change the data source of a PivotTable to a different Excel table or a cell range, click Select a table or range, and then enter the first cell in the Table/Range text box, and select OK