LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 788
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
average Line created in an existing line graph- based on one cell Melanie Charts and Charting in Excel 2 December 27th 07 09:14 PM
Concatenate: Multi-Line Cell with 2 single line cells BEEJAY Excel Worksheet Functions 0 February 15th 07 08:53 PM
Getting line on line chart to display after creation from Pivot Table dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
coloring overy other line without doing so line by line gen Excel Worksheet Functions 5 April 1st 05 10:38 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"