Making a chart from Form Data

[Jan]

I have a database set up so I can enter data in a form
and get a report from that info. Is it possible with
that same data to make a chart also? Would it be easier
to make the chart in access or to export the info in
excel and make a chart that way? How would I do this?

Thanks,
Jan

 

[fredg]

I have a database set up so I can enter data in a form
and get a report from that info. Is it possible with
that same data to make a chart also? Would it be easier
to make the chart in access or to export the info in
excel and make a chart that way? How would I do this?

Thanks,
Jan

Is the Form data bound to a table?
If so, is the chart to be used on the form? Or in the report?

First create the chart on the form.
In design view add a chart to the form.
Click Insert + Chart
Follow the instructions.

Run the form. If all is well and the chart is to be used only on the
form, you're done.
If the chart is to be used in the report, copy (or cut) the chart then
paste it into the report.

 

[Jan]

I would like the chart to be on a report. Also my form is
made from a query. - Jan

 

[Guest]

Sorry mistake....my form is unbound. - Jan

-----Original Message-----


Is the Form data bound to a table?
If so, is the chart to be used on the form? Or in the report?

First create the chart on the form.
In design view add a chart to the form.
Click Insert + Chart
Follow the instructions.

Run the form. If all is well and the chart is to be used only on the
form, you're done.
If the chart is to be used in the report, copy (or cut) the chart then
paste it into the report.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[fredg]

Sorry mistake....my form is unbound. - Jan

*** snipped ***

The data must be stored in a table or a query. Create a table. Bind
each control to a field in the table. Create your chart using this
table as chart RowSource, or make a query using the table data, if
needed, and use the query as chart RowSource.

You can always delete the old records from the table, manually or
using code, if you only wish new data to be used in the chart.