dynamic chart from dynamic columns?

[JMS]

I am hoping someone can tell me about how to do this:

I'm trying to get Access97 to create a nice bar graph for me where the user selects the y and x data from table columns. (i.e. I'm not taking a static set of columns in every case. It changes depending on what display the user asks for.)

Furthermore, these y and x data columns come from an arbitrary table. The table name is known.

The column names in every possible table where the data could come from are the same. Basically each table is the result of a series of inputs and calculations.

Is there some way to get this to work?

 

[JMS]

I just thought of a better way to explain this ...

I'm trying to graph [SomeColumn] vs. [SomeOtherColumn] from [SomeTable] .

And in each possible table, all the columns have the same names. Only the data is different.

Yes, I think that that is a clear explanation.