Charting in Access

  • Thread starter Thread starter Sue M
  • Start date Start date
S

Sue M

Hi there,

I'm having trouble creating a chart in Access.

I read the help instructions which say to put it in a form
or report.

So I tried this, doing and insert chart while in a form.
It all looked to be going well. I chose my table to base
the data on and the mock up chart in the wizard looked
great, showing the right categories etc. Then when I
finish off it inserts a chart with details from what looks
like the help files or examples from the Northwinds
database showing 4 Qtrs and East West and North. What am I
doing wrong??

Cheers,

Sue M
 
Marin:

Actually, that doesn't always work either, and its really sort of a lousy
hack to place the chart on a form first and then copy it to a report. The
issue is a timing issue as to when Graph reads data when placed on a report.

If you look on our web site in the Code and Design tips area under reports,
you'll see a tip related to "Solving Common Problems with Graphs in Access
Reports", that will solve this problem once and for all. Sub item 2 for
that tip shows VB code that can be placed in the On Print event of a report
section containing the Graph object or On Current event of a form to assure
that the data in Graph's data table and design preview of the chart itself
contains the data from the target recordset you are working with.
 
You need to "RUN" the form or report, in order to take the *actual* data
from the table, not the *sample* data from the MS Graph.
Just cpen the Form in Form Veiw (or the Report in Print Preview), the Grpah
control will be populated, and will show the real data. Once you have done
it, when you go to Design view again, it will show the data from the
database, not the sample one.
 
Steve:
Thank you for the link to your web-site.
If a user inserts a Microsoft Graph Object in Word, the sample data is like
that shown in Acess, when the control is plased on form or report.
Maybe MS should take this problem into consideration and patch the MS graph
Object.
 
Marin:

Did you update the report to add the code from the tip on our web (code and
design tips -> reports) to properly refresh the report?
 
Hi Sue and others

I have many graphs in my application and I find it easest to construct the
query on which the graph is based. Then run the query and export this to
Excel. Open your graph that is on the report and then import the data into
the Excel type spread sheet and get the graph to look like you what it should
look then use the same query in the table/query property. In my opinion
Microsoft should fix this graphing tool as some said it Sucks.
 
Back
Top