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

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



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads