Analyzing Data with PivotTables and PivotCharts A1: 411 Q2: A2: You can import data from an Excel PivotTable, but you don't import the structure of the PivotTable. You can insert an Excel PivotTable as an object in an Access form, for example, but you need to acti- vate the object in Excel before you can alter how you view the data in the PivotTable. Even though I see the values along the vertical axis of a PivotChart, I'd like to see the values in the plot area too. Can I do this? Yes. Click the Properties button on the toolbar. On the General tab, select the category field whose values you want to label. In the Add area on the General tab, click the Add Data Label button. On Your Own Use the query named qryTasks to create a PivotTable that shows each task for a country by start date. Use the Assigned To field as the PivotTable's filter. Use the AutoCalc button to show the number of tasks assigned to each campaign. After you complete this chapter: · You'll be able to create a suite of data analysis tools for database applications--queries, reports, Pivot- Tables, and PivotCharts. You can also use PivotTables and PivotCharts on a data access page. For in- formation about data access pages, see Chapter 12, "Access and the Web."