3-D Line -- X,Y,Z
 

Hi,

I have a need to plot a line that has x,y,z co-ordinates (i.e., E/W of
origin, N/S of origin and depth below origin).

The one problem I just realized is that the Z data provided is actually
along the length of the trajectory -- it needs to be projected to the
vertical plane... any quick ideas of how to do that?

I'd like to plot the following data as a line... is that possible?

X Y Z
47.01 0.3 50
89.56 0.01 100
211.78 0.06 150
119.19 0.71 200
99.47 1.06 250
98.15 0.94 300
79.9 1.03 350
80.54 1.07 400
91.43 1.27 450
85.82 1.35 500
89.22 1.38 550
101.6 1.85 600
74.98 2.75 650
72.25 3.89 700
65.03 5.14 750
63.64 5.1 800
57.58 4.14 850
64.73 3.35 900
62.12 3.21 950
60.21 3.62 1000
68.75 2.75 1050
85.01 2.67 1100
85.29 2.97 1123.4

Thanks in advance,
Chris

3-D Line -- X,Y,Z
 

The surface chart in Excel is a category chart and would be of no use to
you.
Sigma Plot and others provide stand-alone and/or Excel add-in alternatives
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chris" wrote in message
...
Hi,

I have a need to plot a line that has x,y,z co-ordinates (i.e., E/W of
origin, N/S of origin and depth below origin).

The one problem I just realized is that the Z data provided is actually
along the length of the trajectory -- it needs to be projected to the
vertical plane... any quick ideas of how to do that?

I'd like to plot the following data as a line... is that possible?

X Y Z
47.01 0.3 50
89.56 0.01 100
211.78 0.06 150
119.19 0.71 200
99.47 1.06 250
98.15 0.94 300
79.9 1.03 350
80.54 1.07 400
91.43 1.27 450
85.82 1.35 500
89.22 1.38 550
101.6 1.85 600
74.98 2.75 650
72.25 3.89 700
65.03 5.14 750
63.64 5.1 800
57.58 4.14 850
64.73 3.35 900
62.12 3.21 950
60.21 3.62 1000
68.75 2.75 1050
85.01 2.67 1100
85.29 2.97 1123.4

Thanks in advance,
Chris

3-D Line -- X,Y,Z
 

Bernard wrote on Tue, 22 Jul 2008 13:53:18 -0300:

The surface chart in Excel is a category chart and would be of
no use to you.
Sigma Plot and others provide stand-alone and/or Excel add-in
alternatives best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chris" wrote in message
...
Hi,

I have a need to plot a line that has x,y,z co-ordinates
(i.e., E/W of origin, N/S of origin and depth below origin).


I don't want to be supercilious but the OP might want to review
elementary Cartesian geometry especially the equations of surfaces and
lines in 3D.
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not