Making One Chart

G

Guest

I want to make one chart that represents info from all of my records. I can
figure out how to insert a chart into a report, but there is one report per
record. This is great, but I only need one chart, not X number of charts.
How do I set up an environment that will allow me to have only one chart.
The only options I see are to install a chart into each form record or
report. Thanks.

Nicole
 
A

Al Campagna

Nicole,
Sounds like you have the chart in the Detail section along with your data. Move it
into some others section, like the Report Footer. The query behind the chart should be
similar to the query behind the report itself. The Detail section displays all the
records, and the Report Footer contains the chart of all the record values.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access 2003 Printing Problem 1
chart on report 2
Multiple charts 1
db Objects and Charts 4
Pie Chart will only Display one slice - 100% 1
Printing a report containing charts 2
Add text box with Total to chart 1
How to count records using count(*) in a chart report 3

Top