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

Chapter 18. Adding Graphs, PivotCharts, ... > Generating Graphs and Charts with Mi...

Generating Graphs and Charts with Microsoft Graph 10

Microsoft Graph 10—called MSGraph in this book—is a 32-bit, OLE 2.0 mini-server application (Graph.exe) that's identical to Access 2000's Graph9.exe and Access 97's Graph8.exe. An OLE mini-server is an application that you can only run from within an OLE container application, such as Access 2002. Word 2002 and Excel 2002 also use MSGraph, which originated as the charting component of Microsoft Excel 5.0. Microsoft encourages use of the PivotChart control for new Access applications, but there's no “PivotChart Wizard” to lead you through the steps to design a PivotChart. The AutoForm: PivotChart option generates a databound form with a PivotChart that you must configure manually, as described in Chapter 12, “Working with PivotTable and PivotChart Views,” and in more detail in the “Working with PivotChart Forms,” section near the end of this chapter.

The sections that follow describe how to use Access's Chart Wizard to add graphs and charts to conventional (Jet) Access 2002 forms and reports. Access Data Projects (ADP) don't support the Chart Wizard, which generates a Jet crosstab query to use as its final data source. As mentioned in Chapter 11, “Creating Multitable and Crosstab Queries,” SQL Server doesn't support the Jet SQL TRANSFORM and PIVOT keywords for crosstab queries. Sections later in the chapter describe how to add bound PivotChart and PivotTable controls to Jet- and SQL Server-based forms and reports.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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