?
Solved

Chart displays sample data

Posted on 2002-07-18
4
Medium Priority
?
287 Views
Last Modified: 2008-02-26
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
0
Comment
Question by:NancyCope
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 5

Expert Comment

by:funke
ID: 7163392
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
 
LVL 1

Author Comment

by:NancyCope
ID: 7163616
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
 
LVL 54

Expert Comment

by:nico5038
ID: 7281494

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
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 7315390
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question