Connect Excel Chart to Access Table

[noboffinme]

Hi

I'm wondering if this is possible first up.

I want to populate my Excel chart series with a Formula that reads an Access table or Query.

I don't want to import any data from Access if I don't need to but just read from Access through the formula & populate the chart.

I'm using an ODBC connection for this by the way. Thanks for any helpful suggestions.