Change the data for a chart in a form or report

Microsoft Office Access 2003

  1. Do one of the following:

    To change the data in an underlying table, open the table in Datasheet view.

    To change the data in an underlying record source that is not a table, open the record source in Design view.

  2. Edit the data.
  3. Open the form in Form view or report in Print Preview to see the chart with current data.

ShowChange the underlying query of the chart

  1. Open the form or report in Design view.
  2. Make sure the chart is selected, and then click Properties Button image.
  3. Click in the RowSource property box, and then click Build Button image to the right of the RowSource property box to open the Query Builder.

    The Query Builder displays the RowSource query in Design view.

  4. Change the query.
  5. To preview your changes, click Datasheet on the View menu.
  6. Close the Query Builder.
  7. Open the form in Form view or report in Print Preview to see the chart with current data.