Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Using a PivotChart to Display and An... - Pg. 399

Analyzing Data with PivotTables and PivotCharts 399 Just the Steps Create a PivotChart 1. 2. 3. 4. In the Database window, click Forms, and then click New. In the New Form dialog box, select AutoForm:PivotChart, and then select the query or table on which you want to base the PivotChart. Click OK. From the PivotChart field list, drag fields to the PivotChart areas for category fields, series fields, data fields, and filter fields. Click the Add Legend button. Working with PivotChart Data and Properties In this section, we'll describe how you can change the ways in which data is displayed in the chart, how to change the type of chart, and how to use properties to change the appearance of a Piv- otChart. Change the orientation and type of a PivotChart 1. 2. If the Expenses_PivotChart form isn't open, select it in the Database window, and then click Open. On the toolbar, click the By Row/By Column button. (You can use ToolTips to help you locate this button.) In this single step, you can see summary data from a different point of view. As you can see here, the chart now shows each expense category for a country grouped together rather than expenses in each category country by country. You could filter the data displayed in the chart