Microsoft Graph Always Shows Sample Data in Design View

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q154454

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

SYMPTOMS

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.

Back to the top

RESOLUTION

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

Back to the top

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:

Create the graph on the form.
Set the graph's Enabled property to Yes and Locked property to No.
Close and save the form.
Open the form in Form view.
Click the Graph object so it has the focus.
On the Edit menu, point to Chart Object and then click Open to start Microsoft Graph.
Note that Microsoft Graph displays the actual data.
On the File menu, click Update.
On the File menu, click Exit & Return to <FormName> (where <FormName> is the name of your form).
Close the form.
Open the form in Design view. Note that the sample data has been replaced by the actual data.

Back to the top

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.

Back to the top

STATUS

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

Back to the top

MORE INFORMATION

Steps to Reproduce Problem

Open the sample database Northwind.mdb.
Open a new, blank form in Design view.
Start the Chart Wizard by clicking Chart on the Insert menu.
Click the Orders table, and then click Next.
Add the EmployeeID and Freight fields to the Fields for Chart box, and then click Finish.
Note that a new graph with sample data displays in Design view.
Open the form in Form view and note that the graph displays the actual data instead of the sample data.
Save and close the form.
Open the form in Design view.
Note that the graph object displays the original sample data, instead of the actual data.

Back to the top

APPLIES TO

Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Back to the top

kbinterop kbpending kbprb KB154454

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top