A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pressure Diagram in Excel 2003



 
 
Thread Tools Display Modes
  #1  
Old March 2nd, 2009, 04:07 PM posted to microsoft.public.excel.charting
raj74
external usenet poster
 
Posts: 24
Default 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  
Old March 2nd, 2009, 08:06 PM posted to microsoft.public.excel.charting
Bernard Liengme[_2_]
external usenet poster
 
Posts: 1,027
Default 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  
Old March 3rd, 2009, 05:45 AM posted to microsoft.public.excel.charting
driller
external usenet poster
 
Posts: 698
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.