You can in fact store a limited amount of data right in the chart, in the
SERIES formula that defines each series. This is troublesome, and is limited
not by number of points, but by number of characters it takes to represent
the data. You can see how to do it he

http://peltiertech.com/Excel/ChartsH...ChartData.html

However, I always advise people to put the data into a worksheet range
somewhere and plot this range. It's easy to see the data and debug the
chart, and there are no arbitrary limits set in the days of limited hardware
capabilities.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"(PeteCresswell)" wrote in message
...
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