Chart displays sample data

I am trying to create a chart on a form in Access.  This morning I was able to do it. Now the query that I used to create this chart has changed and there is an additional category to chart.

I tried starting from scratch with a new report, and I still keep getting the sample data. When I review the report in print preview, it has the correct data. However when I try to open or edit the object from design view, all I get is the sample data. I need to make changes in the colors, text size so I need the real data.

I also saved the report several times and closed and reopened Access without any luck.

Anybody know what is going on and how to fix this?
I am using Access 2000.

Nancy
LVL 1
NancyCopeAsked:
Who is Participating?
 
ComTechConnect With a Mentor Commented:
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0
 
funkeCommented:
ACC: Microsoft Graph Always Shows Sample Data in Design View
PSS ID Number: Q154454
Article last modified on 11-18-1998

7.0 97
WINDOWS
======================================================================
---------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Access versions 7.0, 97
---------------------------------------------------------------------

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.

Additional query words:

======================================================================
Keywords          : FmrHowto IntpGrph kbinterop
Version           : 7.0 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbbug
=============================================================================
Copyright Microsoft Corporation 1998.
-------------------------------------
0
 
NancyCopeAuthor Commented:
THis solution is for Access 7 and Access 97. I am using Access 2000.  I also had a graph working on a report earlier today. The problem started when I changed the query that the graph used. I can still go back to the previously saved database and view this graph. I can also delete the graph from the report and insert a new one, select the query and the data is displayed correctly.

I did notice that I had also created a form with a graph that uses the same query. But I did not copy and paste the graph object.

Nancy
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.