# GrapeCity.Documents.Excel.ISparkVerticalAxis

## Content

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



  <h1 id="GrapeCity_Documents_Excel_ISparkVerticalAxis" data-uid="GrapeCity.Documents.Excel.ISparkVerticalAxis" class="text-break">ISparkVerticalAxis Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the settings for the vertical axes of a group of sparklines.</p>
<p>
Use this interface to configure the minimum and maximum scale behavior for
sparkline vertical axes, including custom axis bounds and scaling options
relative to other sparklines in the same group.
</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_ISparkVerticalAxis_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface ISparkVerticalAxis</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface ISparkVerticalAxis</code></pre>
  </div>
  <h5 id="GrapeCity_Documents_Excel_ISparkVerticalAxis_examples"><strong>Examples</strong></h5>
  <pre><code class="lang-csharp">worksheet.Range["A1:A3"].Value = new object[,] {{10}, {-5}, {20}};
ISparklineGroup sparklineGroup = worksheet.Range["B1:B3"].SparklineGroups.Add(SparkType.Line, "A1:A3");
ISparkVerticalAxis verticalAxis = sparklineGroup.Axes.Vertical;
verticalAxis.CustomMinScaleValue = -10;
verticalAxis.CustomMaxScaleValue = 25;</code></pre>

  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_ISparkVerticalAxis_CustomMaxScaleValue" data-uid="GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMaxScaleValue">
          <a class="xref" href="GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMaxScaleValue.html#GrapeCity_Documents_Excel_ISparkVerticalAxis_CustomMaxScaleValue">CustomMaxScaleValue</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the custom maximum value for the vertical axis of a sparkline.</p>
<p>
Use this property to set or retrieve the manual maximum axis value after the maximum
scale type has been set to <a class="xref" href="GrapeCity.Documents.Excel.SparkScale.html#GrapeCity_Documents_Excel_SparkScale_SparkScaleCustom">SparkScaleCustom</a>.
</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_ISparkVerticalAxis_CustomMinScaleValue" data-uid="GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMinScaleValue">
          <a class="xref" href="GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMinScaleValue.html#GrapeCity_Documents_Excel_ISparkVerticalAxis_CustomMinScaleValue">CustomMinScaleValue</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the custom minimum value for the vertical axis of a sparkline.</p>
<p>
Use this property to set or retrieve the manual minimum axis value after the minimum
scale type has been set to <a class="xref" href="GrapeCity.Documents.Excel.SparkScale.html#GrapeCity_Documents_Excel_SparkScale_SparkScaleCustom">SparkScaleCustom</a>.
</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_ISparkVerticalAxis_MaxScaleType" data-uid="GrapeCity.Documents.Excel.ISparkVerticalAxis.MaxScaleType">
          <a class="xref" href="GrapeCity.Documents.Excel.ISparkVerticalAxis.MaxScaleType.html#GrapeCity_Documents_Excel_ISparkVerticalAxis_MaxScaleType">MaxScaleType</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets how the maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.</p>
<p>
Use this property to determine whether the sparkline group's vertical axis maximum is calculated per sparkline,
shared across the group, or defined by a custom value through <a class="xref" href="GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMaxScaleValue.html#GrapeCity_Documents_Excel_ISparkVerticalAxis_CustomMaxScaleValue">CustomMaxScaleValue</a>.
</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_ISparkVerticalAxis_MinScaleType" data-uid="GrapeCity.Documents.Excel.ISparkVerticalAxis.MinScaleType">
          <a class="xref" href="GrapeCity.Documents.Excel.ISparkVerticalAxis.MinScaleType.html#GrapeCity_Documents_Excel_ISparkVerticalAxis_MinScaleType">MinScaleType</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets how the minimum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.</p>
<p>
The returned <a class="xref" href="GrapeCity.Documents.Excel.SparkScale.html">SparkScale</a> value indicates whether the minimum axis
value is shared by the sparkline group, calculated for each sparkline, or
defined by a custom value.
</p>
</td>
      </tr>
    </tbody>
  </table>

</div>