In MS Access, I can create a chart object, feed it some SQL, and wind up with a
chart that somehow has it's data embedded in the object: user doubleclicks, and
sees the grid containing data.


I'd like to do something like this except that the charts would appear in an
Excel Spreadsheet instead of on an MS Access Form.

Is there any hope? Or should I just allocate one of the spreadsheet's tabs to
"Data", maybe make it invisible, and point all the charts to ranges on that
tab?
--
PeteCresswell