Add3DXYZBarChart Method

The Add3DXYZBarChart method adds a new 3D XYZ bar chart to an existing 3D graph, equivalent to Graph | Add to Graph | Plot. Returns an Auto3DXYZBarChart object.

Syntax

object.Add3DXYZBarChart ( worksheet, xCol, yCol, zCol, xAxis, yAxis, zAxis, id )

Parameter Type Description
worksheet String required, data's full path and file name
xCol Variant optional, default = 1 (column A)
yCol Variant optional, default = 2 (column B)
zCol Variant optional, default = 3 (column C)
id Variant optional, chart name

 

Example

This example shows how to add a 3D XYZ bar chart to an existing 3D XYZ bar chart plot.

'Add a new 3D XYZ bar chart

Set Graph = Plot.Shapes.Add3DXYZBarChartGraph(GrapherApp.Path+"\Samples\barchart.dat",1,2,2)

Graph.Add3DXYZBarChart( GrapherApp.Path + "\samples\barchart.dat", 1, 2, 4)

 

Used by: AutoGraph object

See Also

Add3DXYZBarChartGraph