Create Pivottable Or Pivotchart Views. Once the query has been created try out the following steps to open the query in PivotTable view. Clicking on PivotTable opens the dialog box Create PivotTable and clicking on PivotChart opens the dialog box Create PivotTable with PivotChart.
Add and remove fields in the PivotChart view. Add and remove fields in the PivotChart view. An interactive crosstabulated Excel report that summarizes and analyzes data such as database records from.
Create a PivotChart from a PivotTable Select a cell in the PivotTable you want to convert into a PivotChart.
Add and remove fields in the PivotChart view. Information on this page does not apply to Access 2013 although it is claimed to be applicable to Access 2013 2010. Open a datasheet or form in PivotTable view. Choose the data that you want to analyze.