Problem creating Graph from Chart Wizard

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

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
 
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.
 
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?
 
Back
Top