[Root] / Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ChartCollection Class / Add Method / Add(Int32,Int32,BarChartSubType) Method
The Id of the Row associated with the top left corner of the new BarChart.
The Id of the Column associated with the top left corner of the new BarChart.
The BarChartSubType.
Example


In This Topic
    Add(Int32,Int32,BarChartSubType) Method
    In This Topic
    Adds a OneCellAnchor BarChart to the ChartCollection & allows to specify its sub type.
    Syntax
    'Declaration
     
    
    Public Overloads Function Add( _
       ByVal topLeftRowId As Integer, _
       ByVal topLeftColumnId As Integer, _
       ByVal type As BarChartSubType _
    ) As BarChart
    'Usage
     
    
    Dim instance As ChartCollection
    Dim topLeftRowId As Integer
    Dim topLeftColumnId As Integer
    Dim type As BarChartSubType
    Dim value As BarChart
     
    value = instance.Add(topLeftRowId, topLeftColumnId, type)

    Parameters

    topLeftRowId
    The Id of the Row associated with the top left corner of the new BarChart.
    topLeftColumnId
    The Id of the Column associated with the top left corner of the new BarChart.
    type
    The BarChartSubType.

    Return Value

    The BarChart that has been added to the ChartCollection. 
    Remarks

    Row & Column Ids are used to determine the position of the top left corner of the new BarChart.

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

     

    Example
    // Adds a BarChart with the specific Add method to specify its subType. The top left corner of the Chart will be Cell F6.
    var barChart = worksheet.Charts.Add( 5, 5, BarChartSubType.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