Problem creating Graph from Chart Wizard

[Chuck W]

Hello,

I have a query that has four fields: Month, HandwashRate, HandwashBenchmark,
and Handwash Target. The last three fields all have values between 0 and 1.

Month HandwashRate HandwashBenchmark HandwashTarget
Jan09 .85543 .9 .95
Feb09 .8223 .9 .95


I am attempting to create a line graph using the chart wizard. I want the X
axis to be Month and the Y axis to be a value between 0 and 1. I then want
three lines for my three fields listed above. The chart wizard seem to
demand that I select one of my fields for the Y axis. Can someone help?

Thanks

 

[Duane Hookom]

Just use the wizard to get you started. Then go back and modify the Row
Source of the chart to whatever you want. You can then double-click the chart
in design view to change various properties.

 

[Chuck W]

Duane,
Thanks for your help. I can't seem to get the wizard to complete. Every
combination that I try gives me an error message that states: "You entered
an expression that has an invalid reference to the property". Any idea how
to get beyond this and get the wizard to complete?

 

[Duane Hookom]

Turn the wizard off and then add the chart control to your report.