Pressure Diagram in Excel 2003

[raj74]

I am interested in drawing the following graph:

A pipe profile which is defined by (x,y) say, (x1,y1), (x2,y2).....
Now for a particular value of (x,y) i want the the pressure to be ploted
along y axis.
The data input fpr pressure is like this

For (x1,y1) Pressure p1
(x2,y2) Pressure p2
..........................
.........................
Can this type of superimposed graph is possible in excel. Thanks!!!!!

 

[Bernard Liengme]

Have a look at "surface charts" But Excel is not very good for 3D plots.
The x and y axes are treated as categories as with x-axes in Line plots not
as real numbers as with XY plots. So to get a useful plot, the increments
for each axis must be constant. For example x can be 1, 1.5, 2, 2.5, 3 but
not 1, 1.5, 3, 4.
A true 3D plot is on my Excel wish list.
best wishes

 

[driller]

raj,

I tried a pressurized straight pipe 2-endpoints in a combined
line chart type for the pipe's "Pt. Yn" profile and
"pt. x1" & "pt. x2" assigned as category (x) axis labels and
an area chart type for "pressure" and

Format Data Series>axis>plot series on>secondary axis.

data series in columns...
pressure pt. Yn
"pt. x1" 10 4
"pt.x2" 11 1