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

Chapter 18. Adding Graphs, PivotCharts, ... > Creating a Linked Graph from a Jet C...

Creating a Linked Graph from a Jet Crosstab Query

Access's Chart Wizard is quite parochial: It insists on creating a crosstab query for you. After you've created a chart with the Chart Wizard, however, you can change the graph's Row Source property value to specify a previously created crosstab query of your own design.

Linked graphs or charts display a succession of graphical representations of related data. Linked graphs are useful for delivering more detailed information than bar or area charts can impart. For example, it's difficult to interpret trends for sales of product categories in a stacked area chart. Linked graphs let you drill down into the data behind summary charts and add features to aid data interpretation—such as trendlines. Linked graphs are one of Access 2002's most powerful features.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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