Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been trying to create a simple bar chart in a report with some success
thanks to other questions posted to this discussions group. I have a simple
querywith 9 fields that I wish to see in chart form. I've taken the advice of
creating a form and imbedding in the report, which is good. Then I hit the
snag of the wizard only allowing 6 fields on the chart. I overcame this by
adding fields to my datasheet, which seemed to solve the problem but I can't
see how I can get these additional fields to come from my original query
without manually altering the datasheet. Any help out there?
 
You should be able to set the Row Source of your chart control after the
wizard has run.
 
That has certainly made a difference. Still can't quite make out how to set
the relationship between the cvhart and the query, but I shall have a play
around and see how I get on. Thanks
 
Back
Top