# GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add*">Add Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add*"></a>
<h4 id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_GrapeCity_Spreadsheet_IRange_System_Nullable_GrapeCity_Spreadsheet_Charts_RowCol__System_Nullable_System_Boolean__System_Nullable_System_Boolean__System_Boolean_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add(GrapeCity.Spreadsheet.IRange,System.Nullable{GrapeCity.Spreadsheet.Charts.RowCol},System.Nullable{System.Boolean},System.Nullable{System.Boolean},System.Boolean)">Add(IRange, RowCol?, bool?, bool?, bool)</h4>
<div class="markdown level1 summary"><p>Adds one or more new series to the <a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeriesCollection.html">ISeriesCollection</a> collection.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">ISeries Add(IRange source, RowCol? plotBy = null, bool? seriesLabels = null, bool? categoryLabels = null, bool replace = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function Add(source As IRange, Optional plotBy As RowCol? = Nothing, Optional seriesLabels As Boolean? = Nothing, Optional categoryLabels As Boolean? = Nothing, Optional replace As Boolean = False) As ISeries</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a></td>
      <td><span class="parametername">source</span></td>
      <td><p>The new data as an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.Charts.RowCol.html">RowCol</a>?</td>
      <td><span class="parametername">plotBy</span></td>
      <td><p>Specifies whether the new values are in the rows or columns of the specified range.
If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>?</td>
      <td><span class="parametername">seriesLabels</span></td>
      <td><p><code>true</code> if the first row or column contains the name of the data series.
<code>false</code> if the first row or column contains the first data point of the series.
If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>?</td>
      <td><span class="parametername">categoryLabels</span></td>
      <td><p><code>true</code> if the first row or column contains the name of the category labels.
<code>false</code> if the first row or column contains the first data point of the series.
If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">replace</span></td>
      <td><p>If <code class="paramref">categoryLabels</code> is <code>true</code> and <code class="paramref">replace</code> is <code>false</code>,
the specified categories replace the categories that currently exist for the series.
If <code class="paramref">replace</code> is <code>false</code>, the existing categories will not be replaced.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeries.html">ISeries</a></td>
      <td><p>An <a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeries.html">ISeries</a> object that represents the new series.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add*"></a>
<h4 id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_System_String_System_Nullable_GrapeCity_Spreadsheet_Charts_RowCol__System_Nullable_System_Boolean__System_Nullable_System_Boolean__System_Boolean_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add(System.String,System.Nullable{GrapeCity.Spreadsheet.Charts.RowCol},System.Nullable{System.Boolean},System.Nullable{System.Boolean},System.Boolean)">Add(string, RowCol?, bool?, bool?, bool)</h4>
<div class="markdown level1 summary"><p>Adds one or more new series to the <a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeriesCollection.html">ISeriesCollection</a> collection.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">ISeries Add(string source, RowCol? plotBy = null, bool? seriesLabels = null, bool? categoryLabels = null, bool replace = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function Add(source As String, Optional plotBy As RowCol? = Nothing, Optional seriesLabels As Boolean? = Nothing, Optional categoryLabels As Boolean? = Nothing, Optional replace As Boolean = False) As ISeries</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">source</span></td>
      <td><p>The new data as an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.Charts.RowCol.html">RowCol</a>?</td>
      <td><span class="parametername">plotBy</span></td>
      <td><p>Specifies whether the new values are in the rows or columns of the specified range.
If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>?</td>
      <td><span class="parametername">seriesLabels</span></td>
      <td><p><code>true</code> if the first row or column contains the name of the data series.
<code>false</code> if the first row or column contains the first data point of the series.
If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>?</td>
      <td><span class="parametername">categoryLabels</span></td>
      <td><p><code>true</code> if the first row or column contains the name of the category labels.
<code>false</code> if the first row or column contains the first data point of the series.
If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">replace</span></td>
      <td><p>If <code class="paramref">categoryLabels</code> is <code>true</code> and <code class="paramref">replace</code> is <code>false</code>,
the specified categories replace the categories that currently exist for the series.
If <code class="paramref">replace</code> is <code>false</code>, the existing categories will not be replaced.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeries.html">ISeries</a></td>
      <td><p>An <a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeries.html">ISeries</a> object that represents the new series.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add*"></a>
<h4 id="GrapeCity_Spreadsheet_Charts_ISeriesCollection_Add_GrapeCity_Spreadsheet_WorksheetReference_System_Nullable_GrapeCity_Spreadsheet_Charts_RowCol__System_Nullable_System_Boolean__System_Nullable_System_Boolean__System_Boolean_" data-uid="GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add(GrapeCity.Spreadsheet.WorksheetReference,System.Nullable{GrapeCity.Spreadsheet.Charts.RowCol},System.Nullable{System.Boolean},System.Nullable{System.Boolean},System.Boolean)">Add(WorksheetReference, RowCol?, bool?, bool?, bool)</h4>
<div class="markdown level1 summary"><p>Adds one or more new series to the <a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeriesCollection.html">ISeriesCollection</a> collection.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">ISeries Add(WorksheetReference source, RowCol? plotBy = null, bool? seriesLabels = null, bool? categoryLabels = null, bool replace = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function Add(source As WorksheetReference, Optional plotBy As RowCol? = Nothing, Optional seriesLabels As Boolean? = Nothing, Optional categoryLabels As Boolean? = Nothing, Optional replace As Boolean = False) As ISeries</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.WorksheetReference.html">WorksheetReference</a></td>
      <td><span class="parametername">source</span></td>
      <td><p>The new data as an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.Charts.RowCol.html">RowCol</a>?</td>
      <td><span class="parametername">plotBy</span></td>
      <td><p>Specifies whether the new values are in the rows or columns of the specified range.
If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>?</td>
      <td><span class="parametername">seriesLabels</span></td>
      <td><p><code>true</code> if the first row or column contains the name of the data series.
<code>false</code> if the first row or column contains the first data point of the series.
If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>?</td>
      <td><span class="parametername">categoryLabels</span></td>
      <td><p><code>true</code> if the first row or column contains the name of the category labels.
<code>false</code> if the first row or column contains the first data point of the series.
If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">replace</span></td>
      <td><p>If <code class="paramref">categoryLabels</code> is <code>true</code> and <code class="paramref">replace</code> is <code>false</code>,
the specified categories replace the categories that currently exist for the series.
If <code class="paramref">replace</code> is <code>false</code>, the existing categories will not be replaced.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeries.html">ISeries</a></td>
      <td><p>An <a class="xref" href="GrapeCity.Spreadsheet.Charts.ISeries.html">ISeries</a> object that represents the new series.</p>
</td>
    </tr>
  </tbody>
</table>
</div>