Excel Style Chart In Access

[danielhitch]

Access has very limited charting for what I need to produce.

I need to produce a scatter chart from my query - but i need the functions that excel offers that access doesn't.

Is there a way to link an access query to an excel ole object inserted into a form?

Data:

I have one column of X values
I have one column of Y values
I have 3 series (1,2,3)

Thanks!

 

[Trevor G]

In a form you can add an unbound object frame, that will then give you options to link to excel and charts.

 

[danielhitch]

I know this, but i need the charts to be linked to an access query and not an excel table.

Thanks