DataBarAxisPosition Enumeration

Specifies the position of the axis.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum DataBarAxisPosition 
   Inherits System.Enum

'Usage
 
Dim instance As DataBarAxisPosition

public enum DataBarAxisPosition : System.Enum

Members

Member	Description
Automatic	Indicates whether to display at a variable position based on negative values.
CellMidPoint	Indicates whether to display at the cell midpoint.
None	Indicates whether to display value bars in the same direction as positive values.

Example

This example sets the DataBarAxisPosition enumeration.

gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = 3; 

GrapeCity.Windows.SpreadSheet.Data.DataBarRule test = new GrapeCity.Windows.SpreadSheet.Data.DataBarRule();
test.AxisColor = Color.FromArgb(101, 50, 50, 200);
test.AxisPosition = GrapeCity.Windows.SpreadSheet.Data.DataBarAxisPosition.CellMidPoint;
test.BorderColor = Color.FromArgb(150, 10, 100, 99);
test.ShowBorder = true;
test.DataBarDirection = GrapeCity.Windows.SpreadSheet.Data.BarDirection.RightToLeft;
test.MaximumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.HighestValue;
test.MinimumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.LowestValue;
test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);

VB.NET

GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = 3

Dim test As New GrapeCity.Windows.SpreadSheet.Data.DataBarRule()
test.AxisColor = Color.FromArgb(101, 50, 50, 200)
test.AxisPosition = GrapeCity.Windows.SpreadSheet.Data.DataBarAxisPosition.CellMidPoint
test.BorderColor = Color.FromArgb(150, 10, 100, 99)
test.ShowBorder = True
test.DataBarDirection = GrapeCity.Windows.SpreadSheet.Data.BarDirection.RightToLeft
test.MaximumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.HighestValue
test.MinimumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.LowestValue
test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.DataBarAxisPosition

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace