Create a PivotChart - Microsoft Support
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.
Overview of PivotTables and PivotCharts - Microsoft Support
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 …
Pivot data in a PivotTable or PivotChart - Microsoft Support
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 …
Expand, collapse, or show details in a PivotTable or PivotChart ...
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 …
Sort data in a PivotTable or PivotChart - Microsoft Support
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. …
Use PivotTables and other business intelligence tools to analyze …
Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the …
Group or ungroup data in a PivotTable - Microsoft Support
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and …
Calculate values in a PivotTable - Microsoft Support
PivotTables provide ways to calculate data. Learn about the calculation methods that are available, how calculations are affected by the type of source data, and how to use formulas in …
Rename a field or item in a PivotTable or PivotChart
PivotChart report. Click the object in the chart (such as a bar, line, or column) that corresponds to the field or item that you want to rename. Go to PivotTable Tools > Analyze, and in the Active …
Show different calculations in PivotTable value fields
Show different calculations in PivotTable value fields. Applies To. Instead of writing your own formulas in calculated fields, you can use Show Values As to quickly present values in …