Creating chart on a report

G

Guest

Trying to create a chart on a report. The chart is based on a query with the
following data:
Qtr1 '04 Qtr2 '04 Qtr3 '04 Qtr4 '04
Admin 21 37 43 25

Chart wizard does not give expected results. I tried to customize the
results without any luck. I can see the result in design view, but when I
switch to Report view, I see the chart created by the wizard.

Many thanks for any help you can provide,
Marie
 
D

Duane Hookom

Make sure the Row Source property of the chart control is exactly like you
expect the chart data. View the datasheet of the Row Source and select and
copy all records. Then close up the Row Source and double-click the chart
control. You can view the datasheet of the chart control and paste your
data. Then save the chart control.
 

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

chart blank on report 3
Changing chart labels in an Access report 1
Need help on chart 1
Chart based on data from report 3
Chart based on data in the report 1
Creating a Chart in a Report 1
tallying occurrences independently in a query? 3
print Report Footer on 2nd to last page and a chart on last page 1

Top