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
PivotCharts display data series, categories, data markers, and axes just as standard charts do. You can also change the chart type and other options such as the titles, the legend placement, the data …
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 collapse to a …
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. Sorting is one …
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 …
Use a screen reader to create a PivotTable or PivotChart in Excel
Use a PivotTable to calculate, summarize, and analyze data. You can quickly create comparisons, patterns, and trends for your data. With a PivotChart, you can present your data visually, and quickly …
Create a PivotTable to analyze worksheet data - Microsoft Support
Choose where you want the PivotTable report to be placed. Select New Worksheet to place the PivotTable in a new worksheet or Existing Worksheet and select where you want the new PivotTable …
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.
Using charts and PivotChart reports in a workbook in the browser
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 view charts, chart …
Overview of PivotTables and PivotCharts - Microsoft Support
PivotCharts display data series, categories, data markers, and axes just as standard charts do. You can also change the chart type and other options such as the titles, the legend placement, the data …
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.