Variable X axis on a Chart

[InQuery2004]

Hello,

Would anyone know whether it's possible to create a Chart for a form in ACCESS whose X-axes varies depending on the value selected in a Combo Box. The Combo Box shall contain entries that represent fields in the query that serves as the RowSource for that Graph.

So for example, suppose the Combo Box has 3 values: Date, ItemType and ItemNo. By selecting Date on the the Combo box, I would like to immediately replot the graph to for Quantity vs. Date. If I select, ItemType, the graph would be regenerated for Quantity vs. ItemType.

Thus, only the x-axes parameter varies.

How would I go about doing this? If this question has been asked before, please post a link to the solution.

Thanks for your time and effort.

Regards,

Mike J.

 

[InQuery2004]

I noticed that although my post has had some views, no one has yet replied.

Perhaps I'm being too impatient, but I am curious to know. Is my issue too complicated to resolve with/ cannot be solved or is it that most of you don't understand my original post.

Or is the underlying issue altogether different. Perhaps my screen name is too cheesy-sounding for me to be take seriously? (I agree that it does sound cheesy)

If the problem is the latter, I will be glad to rephrase my problem.

Regards,

Mike J.

 

[InQuery2004]

Come on Folks,

I need to create the aformentioned graph ASAP (I have a deadline coming up with my supervisor).

If my aim cannot be done, please say so, and present and alternative solution, if possible. If my original post is too ambiguous, then I'll clarify my original requirement...I just require feedback on this...