I have an app built in Access 2007. At one point, I have an MS Graph object on a sub form. I set the row source type as "Table/Query" and the row source as a SQL query against a local table. The make-up of the query depends on the objective to be shown in the graph.
Depending upon my needs, I change the graph type from XY Scatter to Bubble Chart as needed and coordinate the query to support the type.
Frequently, but for no reason I have been able to determine, even though I have proper data in the Datasheet as a result of the query, the graph seems to be "disconnected" from the datasheet.
I have been having a long discussion in
but now must close that out. Based on help I got there, I know I have the correct organization of data in my datasheet for an XY Scatter (X,Y,S). Here is a sample:
Business_Score Technical_Score Application_Name
2.724206 2.748611 AAAAA
3.425397 3.417583 BBBBB
3.32619 3.274214 CCCCC
3.452381 3.372123 DDDDD
3.04881 3.363636 EEEEE
3.225397 3.363636 FFFFF
3.68718 3.542456 GGGGG
3.971825 2.971705 HHHHH
4.360714 3.276933 IIIII
There are actually 86 rows in the datasheet. Every cell that should be filled is.
But, when I look at the graph, there are only 5 points plotted, none of which relate to any of the values in the datasheet.
At other times, when I set the row source query to produce data for a Bubble Chart, and then try to change the chart type to Bubble Chart, I either get a message saying I must have 2 or more points to plot before I can change it to Bubble Chart (there are 86 in the datasheet) or I get an object error. Then, still other times, it works as expected.
I have compacted and repaired the accdb numerous times, and have built a new accdb and imported all components. This problems comes and goes.
How does this "disconnect" happen and more importatnly what steps can I take to prevent it? I must be able to control this so my users do not run into it.