xy scatterplots and trendlines for forms.

[access_numpty]

Hi,

I haven't too much experience with access.

I have a list of measurements, and the dates on which they were measured for a certain item. So I have multiple measurements on different dates for each item.

What I would like to do is create an x-y scatter plot of date (x) against measurement with a trendline for each item and show this in a form.

How do I go about doing this?

 

[ChrisO]

Welcome to the site.

Something in the sample databases forum might help.

There’s a fair amount of work involved to get something reasonable so you will need to learn some VBA as well.

Hope that gives you a start.

Regards,
Chris.