# GrapeCity.Documents.Excel.DataBarAxisPosition

## Content

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




  <h1 id="GrapeCity_Documents_Excel_DataBarAxisPosition" data-uid="GrapeCity.Documents.Excel.DataBarAxisPosition" class="text-break">DataBarAxisPosition Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the axis position for a range of cells with conditional formatting as data bars.</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_DataBarAxisPosition_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum DataBarAxisPosition</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum DataBarAxisPosition</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_DataBarAxisPosition_Automatic">Automatic</td>
        <td><p>Displays the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values
are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values
are negative, no axis is displayed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_DataBarAxisPosition_Midpoint">Midpoint</td>
        <td><p>Displays the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction.
Negative values are displayed in a right-to-left direction.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_DataBarAxisPosition_None">None</td>
        <td><p>Specifies that no axis is displayed, and both positive and negative values are displayed in the left-to-right direction.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>