Graphs in a Form .... HOW?

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

I may not be making my question about graphs in a form
clear enough for anyone to answer ... but I DO NEED HELP!

All I want to do is include a simple pie chart on a form
that illustrates to my user what percentage of a given
customer's balance is current or overdue. Ideally, this
would be broken up into 0-30 days, 30-60 days, 60-90 days,
and over 90 days.

When I try to create a pie chart using the wizard I get
nowhere. This seems like it should be as easy as, well
PIE! But alas. PLEASE give me some direction on this - I
don't necessarily need a detailed solution. Are there
articles I can refer to? Thanks for any help!

Marty
 
Marty,

First, create a query that shows the data you wish and save it. You can use
a dynamic query but while you're learning, it's much easier to work with a
query you know is right.

Some instructions for a using MsGraph with Access.

The Chart Wizard in Access leaves much to be desired,
ie: you're not limited to 6 Series.

Take a blank Form (even if you're making a graph for a Report)
and insert an unbound object frame:
Insert/Object, select Ms Graph (*Not* the Chart Wizard)

Click on the detail of your Form (ie: click off the graph)

Open the properties of the Graph object:
Format Tab: Size Mode - Zoom
Column Heads - Yes
Data Tab: Row Source Type - Table/Query
Row Source - Enter the name of your table, CrossTab Query, Select Query or
SQL
Enabled - Yes
Locked - No

View the form then go right back to design view (this will load
the graph datasheet with your data vs the sample data).
Don't worry about what the graph looks like just yet.

Then right click the Graph and select Chart Object ->Open (not Edit)

Make sure the Data/Series is in Rows or Columns - whatever is
appropriate for your data.

Now you have something to work with. Select the graph type (ie: Pie)
and any formatting you wish.

The Row Source can be a table or query name or a sql statement which
makes it very nice for dynamic data.

Using automation you can dynamically change the graph
to suit your needs.

If you're *really* making a report, now copy the Graph object
from the form to the report.

Download the Graph Sample MDB from MsKb Q186855, Grphsm97.Exe
and convert it to a newer version of Access if req'd.

Study the Graph Help file Graph9.hlp (A97) or Graph9.chm (A2k)
Study the Graph object Methods and Properties in the Access Object Browser

Also get the automation help files appropriate for you
for various help in coding:

Q302460 Office XP Products
Q260410 Office 2000 Products
Q167223 Office 97 Products
 
-----Original Message-----
Marty,

First, create a query that shows the data you wish and save it. You can use
a dynamic query but while you're learning, it's much easier to work with a
query you know is right.

Some instructions for a using MsGraph with Access.

The Chart Wizard in Access leaves much to be desired,
ie: you're not limited to 6 Series.

Take a blank Form (even if you're making a graph for a Report)
and insert an unbound object frame:
Insert/Object, select Ms Graph (*Not* the Chart Wizard)

Click on the detail of your Form (ie: click off the graph)

Open the properties of the Graph object:
Format Tab: Size Mode - Zoom
Column Heads - Yes
Data Tab: Row Source Type - Table/Query
Row Source - Enter the name of your table, CrossTab Query, Select Query or
SQL
Enabled - Yes
Locked - No

View the form then go right back to design view (this will load
the graph datasheet with your data vs the sample data).
Don't worry about what the graph looks like just yet.

Then right click the Graph and select Chart Object ->Open (not Edit)

Make sure the Data/Series is in Rows or Columns - whatever is
appropriate for your data.

Now you have something to work with. Select the graph type (ie: Pie)
and any formatting you wish.

The Row Source can be a table or query name or a sql statement which
makes it very nice for dynamic data.

Using automation you can dynamically change the graph
to suit your needs.

If you're *really* making a report, now copy the Graph object
from the form to the report.

Download the Graph Sample MDB from MsKb Q186855, Grphsm97.Exe
and convert it to a newer version of Access if req'd.

Study the Graph Help file Graph9.hlp (A97) or Graph9.chm (A2k)
Study the Graph object Methods and Properties in the Access Object Browser

Also get the automation help files appropriate for you
for various help in coding:

Q302460 Office XP Products
Q260410 Office 2000 Products
Q167223 Office 97 Products






.
To Steve T:
Click to expand...

Thank you VERY much for your assistance!! With your help,
I was able to accomplish what I needed in a very short
time. Your instructions were very clear, and after I
printed them I realized that you had written an entire
page loaded with good information! I'm sure this took you
some time, and it's very much appreciated, Steve.
 
Back
Top