Microsoft Graph Always Shows Sample Data in Design View (154454)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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.
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:
- 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.
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.
Modification Type: | Major | Last Reviewed: | 10/29/2003 |
---|
Keywords: | kbinterop kbpending kbprb KB154454 |
---|
|