YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Creating XY graph in Processbook Options · View
jiteshraniga
#1 Posted : Wednesday, November 02, 2011 4:39:00 AM
Rank: Member
Groups: Member

Joined: 6/9/2011
Posts: 12
Location: Brisbane
Hi,

I am trying the represent the current vertical temperature profile of a vessel in Processbook. What the end product needs to be is the x-axis (distance up a vessel) should be constant and defined by me and the y-axis contain the various current values (updating continuously) of temperatures with each coressponsing to a certain x -value.

Now the XY plot in processbook doesn't suit this application. What is the best way to get this created? It is very easy to make the graph in excel but when I embed it in processbook the graph doesn't update unless you double click and go into the excel environemnt. I haven't been able to make it with any of the readily available processbook graphing tools.

Any help is appreciated.

Regards,
Jitesh
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
caffreys_col
#2 Posted : Wednesday, November 02, 2011 9:08:53 AM
Rank: Advanced Member
Groups: Member

Joined: 4/6/2011
Posts: 40
Location: Grimsby UK
Hi Jitesh,

I can't think of anyway to do it using the XYplot in processbook, but if your are embedding an Excel sheet into Processbook, then you should be able to cheat, by using the Display_dataupdate() VBA function. You will have to play with the VB code to get a reference to the Excel sheet and to get it to update, but that shouldn't be too difficult (some on here has probably already done it). You might need to put a value/trend/bar chart in the same Processbook display as the Excel sheet, and whenever the display gets updated the Excel sheet will update.

something like...
Private Sub Display_DataUpdate()
'update excel sheet code
End Sub

Sorry I can't give you the exact code but I'm sure there are some examples on here from previous posts. Pray

Rgds

Caffreys
squatty
#3 Posted : Wednesday, November 02, 2011 9:50:13 AM
Rank: Advanced Member

Groups: Member

Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
Hi jiteshraniga

I'm not 100% sure what you are asking, do you want to display a XY PLot graphically or do you only what to be able to ascess the math part of it.

You can try using a dataset for your constants on one axis and variable (tags) for the other axis. If you only want to get the corresponding x value for a dynamic changing graph I would reccommend you look into the Curve function in PI

Curve(x,(x1,y1)(x2,y2)(x3,y3)(x..n,y..n))
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.