Insert Chart into Access 2007 Report

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cowboyjunkey

    Insert Chart into Access 2007 Report

    This is what I want to do:

    Each report page will list some details about a sample (like time
    sampled, where, who sampled) and below it a chart showing the
    distribution of the sample (i.e. numbers in categories of less than 2
    oz, 2-2.5oz, 2.5oz-3oz, etc.)

    I thought that I could add a chart just like in Excel but either I
    cannot or am doing something very wrong. In Report Design I click on
    Design at the top and then Insert Chart

    The first problem I have is that I can only add 6 fields from each
    record (and I have more categories for the chart than that).

    The second problem is that the chart only gives a sum of the field for
    all records and places that chart on all report pages (one page per
    record).

    And finally - it shows the sample data and not my data in the design,
    report, and print preview!

    Any help would be appreciated,
    Scott.
Working...