graphs and multiple sheet workbooks, Excel 97

[liz]

is it possible to create a scatter diagram (or other graph)
using the same particular cell on each of several sheets
in a workbook?

 

[Jon Peltier]

Liz -

Without processing the data, this only works if each point is to be its
own data series. This isn't very likely or convenient.

You can use formulas to get that data onto the same sheet, as shown in
this web page:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

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