Add points, zoom in charts

[Terzaghi]

I would like to allow a user to click on a blank chart to input a series of data points. For example, if the user is outlining the stratigraphy of site, instead of entering a bunch of x,y coordinates in cells, I would like to use VBA to read the clicked points and use those points to perform future calculations.

I am also interested in creating a "zoom" feature where a user could draw a little rectangle or somehow indicate with a mouse the upper and lower limits of the x and y axis.

Has anybody done this or have ideas on how it might be done?

 

[CarlB]

It sounds to me you're wanting to do something better suited to a CAD program - in fact built right in. Maybe a little customization of a CAD program will fit the bill, rather than "arm-twisting" Excel to do it. Maybe someone knows of a simplew indows CAD program that may be appropriate.

Terzaghi......are you related to the "Father of Soil Mechanics"?

Carl

 

[GregLocock]

I'd write a Qbasic program to do that.

Here's a program that does what you want: 3DField at field.hypermart.net Cheers

Greg Locock