ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Horizontal and Vertical Charts (https://www.excelbanter.com/charts-charting-excel/205326-horizontal-vertical-charts.html)

CHKMSTrainer

Horizontal and Vertical Charts
 
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

Horizontal and Vertical Charts
 
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.





All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com