If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!!!!! |
#2
|
|||
|
|||
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!!!!! |
#3
|
|||
|
|||
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!!!!! |
Thread Tools | |
Display Modes | |
|
|