Horizontal and Vertical Charts

[CHKMSTrainer]

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.

 

[Jon Peltier]

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

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

- Jon