ACC: Microsoft Graph Always Shows Sample Data in Design View

ID: Q154454

The information in this article applies to:

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

After you insert a Microsoft Graph object into a Microsoft Access form or report, the graph object always displays sample data in Design view. This occurs even if you have opened the form or report, and the graph object correctly displays the actual data in Form view or Print Preview.


RESOLUTION

The resolution to this problem depends upon whether you are using the graph in a form or a report.

Form

To update the form's Design view with the graph's actual data, you must activate Microsoft Graph while the actual data is being charted in Form view. To view actual data in the chart in Design view of the form, follow these steps:
  1. Create the graph on the form.


  2. Set the graph's Enabled property to Yes and Locked property to No.


  3. Close and save the form.


  4. Open the form in Form view.


  5. Click the Graph object so it has the focus.


  6. On the Edit menu, point to Chart Object and then click Open to start Microsoft Graph.


  7. Note that Microsoft Graph displays the actual data.


  8. On the File menu, click Update.


  9. On the File menu, click Exit & Return to <FormName> (where <FormName> is the name of your form).


  10. Close the form.


  11. Open the form in Design view. Note that the sample data has been replaced by the actual data.


Report

Because Microsoft Graph objects cannot be activated during print preview, there is no way to directly update reports with the actual charted data. In order to see the actual charted data in Design view of reports, you must first create the graph in a form, follow the previous steps in the "Form" section to view the actual data in the form, and then copy and paste the updated graph object into your report.

NOTE: The actual charted data shown in Design view of reports is static. Reports cannot automatically update graphs in Design view as forms can. each time you want to see the latest charted data in Design view of the report you must follow the steps in the "Form" section and then copy and paste the updated graph object into your report.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.


MORE INFORMATION

Steps to Reproduce Problem


  1. Open the sample database Northwind.mdb.


  2. Open a new, blank form in Design view.


  3. Start the Chart Wizard by clicking Chart on the Insert menu.


  4. Click the Orders table, and then click Next.


  5. Add the EmployeeID and Freight fields to the Fields for Chart box, and then click Finish.


  6. Note that a new graph with sample data displays in Design view.


  7. Open the form in Form view and note that the graph displays the actual data instead of the sample data.


  8. Save and close the form.


  9. Open the form in Design view.


  10. Note that the graph object displays the original sample data, instead of the actual data. 



Keywords          : kbinterop FmrHowto IntpGrph 
Version           : 7.0 97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 20, 1999