Graph Axis Problem

[SteveC24]

Hi,

I have now managed to make myself a graph that works. The only problem is, the x axis contains the record ID, as opposed to a date.

If in the chart wizard, I select the x axis to be the date, that is great, but then the values of all the water tests insist on being summarised in some way, for example, SUM. This is no use.

Can anyone help?

PS> I have attached a picture of how it looks with the recordID as the x axis, those I would ideally like changed to dates.

 

[adam_fleck]

Tricky One

One of the things you could do is set up a query that converts dates into text values, then base your chart on that query.

Set up a new query as you normally would and include all the fields from your results table. Then scroll to the first blank cell in the top row of the grid and paste in the following:

txt_date: Format$([t_date],"dd/mm/yy")

You'll need to edit t_date so that it refers to the field you're using to record test dates.

Save the query as "qry_chart_1" or something, and base your chart on this query, using txt_date rather than t_date as the first field you select for your chart data.

If more than one set of test results will be entered each day, and you want to graph each set of reults seperately without summarizing, change the formula in the query to:

txt_date: Format$([t_date],"dd/mm/yy hh:nn")

This should do it. But you'll probably need to design the report, double click on the chart object, then right click on the x axis and select Format Axis from the popup menu. It will probably take quite a bit of experimentation to get things working more or less exactly as you want.

 

[SteveC24]

Thank you for your assistance! I will give that a go, and see how I get on. Since I originally posted, I have had a couple of ideas about ways around this, but will try your method first.

Thank you again.