I have a user trying to create a contour chart or any chart for that matter
using values from different spreadsheets going horizontally and vertically.
These are well depths so, when one value ends vertically on one of the
spreadsheets the next spreadsheet begins horizontally. Is there a way to
effectively and attractively create this kind of spreadsheet? Please let me
know.

There are limitations to using dispersed data in charts. It's best to
compile the data in a single sheet.

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

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


"CHKMSTrainer" wrote in message
...
I have a user trying to create a contour chart or any chart for that matter
using values from different spreadsheets going horizontally and
vertically.
These are well depths so, when one value ends vertically on one of the
spreadsheets the next spreadsheet begins horizontally. Is there a way to
effectively and attractively create this kind of spreadsheet? Please let
me
know.