Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ChartCollection Class / Add Method / Add(String,ColumnChartSubType) Method
The Address of the Cell corresponding to the top left corner of the new ColumnChart.
The ColumnChartSubType.
Example


In This Topic
    Add(String,ColumnChartSubType) Method
    In This Topic
    Adds a OneCellAnchor ColumnChart to the ChartCollection & allows to specify its sub type.  
    Syntax
    'Declaration
 

    Public Overloads Function Add( _
   ByVal topLeftCellAddress As String, _
   ByVal type As ColumnChartSubType _
) As ColumnChart
    'Usage
 

    Dim instance As ChartCollection
Dim topLeftCellAddress As String
Dim type As ColumnChartSubType
Dim value As ColumnChart
 
value = instance.Add(topLeftCellAddress, type)
    public ColumnChart Add( 
   string topLeftCellAddress,
   ColumnChartSubType type
)

    Parameters

    topLeftCellAddress
    The Address of the Cell corresponding to the top left corner of the new ColumnChart.
    type
    The ColumnChartSubType.

    Return Value

    The ColumnChart that has been added to the ChartCollection.  
    Remarks

    An Address is used to determine the position of the top left corner of the new ColumnChart.

    The Chart's Width & Height can then be used to determine its size.

     

    Example
    // Adds a ColumnChart with the specific Add method to specify its subType. The top left corner of the Chart will be Cell F6.
var columnChart = worksheet.Charts.Add( “F6”, ColumnChartSubType.Stacked );
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    ChartCollection Class
    ChartCollection Members
    Overload List

    Send Feedback