• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Adding Graphs, PivotCharts, ... > Substituting or Adding a PivotTable ...

Substituting or Adding a PivotTable in a Form

PivotCharts rely on an underlying PivotTable to supply data to the chart or graph. Thus, it's easier to alter a form or subform to display a PivotTable instead of a PivotChart. For example, you can open the sbf1997SalesPivotChart subform in design view and change its AllowPivotChartView property value to No, AllowPivotTableView to Yes, and DefaultView to PivotTable.

When you open frm1997SalesPivotChart, the PivotTable appears as shown in Figure 18.44. Months are row headings and product categories are column headings, so you might want to pivot the table to correspond to the graph layout. In this case, you must mark the Field Buttons/Drop Zones check box on the PivotChart Property dialog's Show/Hide page to enable pivoting when you change to PivotTable view.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint