Single Data Point on Chart

[kingofthekassel]

I am creating a form and need to include a data chart that only has one point. I want to use the data from a query I created to populate the graph. It would be just a simple XY graph. Normally I would just pick the data point that I need and be done with it, but I have over 500 data points and more on the way. I want to organize the graphs by "FieldA" and be able to cycle through any value in "FieldA" and have the graph give me the corresponding points which are located in "FieldB" and "FieldC" respectively. Thanks for the help!

[June7]

So you need to filter the graph RowSource? The RowSource can be a table, query, or sql statement. I always use an sql statement.

SELECT FieldB, FieldC FROM tablename WHERE FieldA=[input parameter here];

The [input parameter here] can be reference to a control on form or report.

SELECT FieldB, FieldC FROM tablename WHERE FieldA=[textboxname];

The WERE clause will synchronize the graph with current record on form or report.

[kingofthekassel]

Thanks a lot! It works, almost. What it is doing is actually plotting two points. The points have the Coordinates as both of their Y-components. For example, if an object in "FieldA" has coordinates (3,3) the two points on the graph will have (1,3) and (2,3). I am not sure how I should fix this.

[June7]

I analyze graph issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.

[kingofthekassel]

Ok, here is the internet safe version of the database with NTK info only.

[June7]

I open your form and get a bunch of input prompts. Why? Why are fields in the form RecordSource with alias names (Expr1, Expr2, etc)? I modified to:

SELECT Risks.*, RiskSupp.[SPO PM], RiskSupp.[SPO POC], RiskSupp.[Alt POC], RiskSupp.[NGC PM] FROM RiskSupp INNER JOIN Risks ON RiskSupp.[RiskNo] = Risks.RiskNo;

Change the graph RowSource to:

SELECT [FirstConsequence], [First Probability] FROM FinalRiskQuery Where RiskNo = RiskNo;

The first field is the x-axis, other fields are y-axis.