Chart wizard - how to manipulate data into correct field

[Guest]

I am trying to draw a graph from a query to show Date (dd/mm/yy) along the x
axis and pH on the y axis.

Using create a new form -

- select chart wizard and the relevant query
- select date and pH value for fields for chart
- select line for chart type
- Layout of data shows (imagine graph axis below)

Date

pH value


Date by month

If I preview or finish the chart, the x axis does have the date but the y
axis only has the values 0 to 1.2 and all the data points are at 1. Instead
of 1 series for pH, each data entry has its own series and this is shown in
the legend box.

Help – I’m not sure what to do to manipulate the data correctly to show 1 pH
series containing all the data points. Also is it possible to add another
series on the same chart for example iron concentration?

Thank you!

 

[Penguin]

First check that the data is correct in the query. If all data looks
correct then make sure the chart has the properties Enabled = Yes and
Locked = No. In form view double click on the chart to see the design
view of the chart. Now all the data is now in the datasheet of the
chart design. Check to see if all data is laid out correctly. If not
then you need to redo the query so it presents the data to the chart
correctly. If all is good then play around with showing the data on
the chart in rows or columns. Let me know how you make out.