AddPiperGraph Method

The AddPiperGraph method creates a new piper diagram. Returns an AutoGraph object.

Syntax

object.AddPiperGraph( worksheet, xCationCol, yCationCol, zCationCol, xAnionCol, yAnionCol, zAnionCol, id )

 

Parameter	Type	Description
worksheet	String	required, data's full path and file name
xCationCol	Variant	optional, default = 1 (column A)
yCationCol	Variant	optional, default = 2 (column B)
zCationCol	Variant	optional, default = 3 (column C)
xAnionCol	Variant	optional, default = 4 (column D)
yAnionCol	Variant	optional, default = 5 (column E)
zAnionCol	Variant	optional, defalut = 6 (column F)
id	Variant	optional, graph name

 

Remarks

The AddPiperGraph method creates a piper diagram, which consists of three ternary plots: cation, anion, and diamond. The example shows how to set the references to the AutoTernaryPlot objects.

Example

This example shows how to create a piper diagram and set the references to the component plots.

'Create Piper reference

Dim Piper as Object

 

'Create the piper diagram and set the reference

Set Piper = Shapes.AddPiperGraph(GrapherApp.Path + "\samples\piper.dat",3,2,4,6,7,5)

 

'Set the Cation plot reference

Dim Cation as Object

Set Cation = Piper.Plots.Item(1)

 

'Set the Anion plot reference

Dim Anion as Object

Set Anion = Piper.Plots.Item(2)

 

'Set the Diamond plot reference

Dim Diamond as Object

Set Diamond = Piper.Plots.Item(3)

 

Used by: AutoShapes collection