AddChart(String,SpreadChartType,String,String,String,Double,Double,Double,Double) Method
In This Topic
Adds the chart in the sheet.
Syntax
'Declaration
Public Overloads Function AddChart( _
ByVal As String, _
ByVal As SpreadChartType, _
ByVal As String, _
ByVal As String, _
ByVal As String, _
ByVal As Double, _
ByVal As Double, _
ByVal As Double, _
ByVal As Double _
) As SpreadChart
'Usage
Dim instance As Worksheet
Dim name As String
Dim chartType As SpreadChartType
Dim itemsFormula As String
Dim nameFormula As String
Dim dataFormula As String
Dim x As Double
Dim y As Double
Dim width As Double
Dim height As Double
Dim value As SpreadChart
value = instance.AddChart(name, chartType, itemsFormula, nameFormula, dataFormula, x, y, width, height)
Parameters
- name
- The name of the chart.
- chartType
- The type of the chart.
- itemsFormula
- The item label formula.
- nameFormula
- The series name formula.
- dataFormula
- The data formula.
- x
- The x value or left position.
- y
- The y value or top position.
- width
- The width of chart.
- height
- The height of chart.
See Also