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