Video Create Pivottable And Analyze

Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.

Video Create Pivottable And Analyze. With a PivotTable selected browse to the Analyze Change Data Source option. While a PivotChart shows data series categories and chart axes the same way a standard chart does it also gives you interactive filtering controls right on the chart so you can quickly analyze a subset of your data.

1
1 from encrypted-tbn0.gstatic.com

Ill select the Sales Revenue field since this is a numerical data type it is automatically added to the Values area. Right-click any cell in the Sum of Order Amount column. The recommended PivotTable feature offers a variety of one click options to analyze your data.

Formulas pivot tables macros VBA charts dashboards Power.

Im going to zoom in a little to make the PivotTable easier to read. Ill select the Sales Revenue field since this is a numerical data type it is automatically added to the Values area. And the numbers in the column are formatted as currency. For information about using multiple database tables see Create a PivotTable to analyze data in multiple tables.