Pressure Diagram in Excel 2003
 

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!!!!!

Pressure Diagram in Excel 2003
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"raj74" wrote in message
...
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!!!!!

Pressure Diagram in Excel 2003
 

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 Seriesaxisplot series onsecondary axis.

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

--
regards

"raj74" wrote:

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!!!!!