GemBox.Spreadsheet
  • Overview
  • Examples
  • Free version
  • Support
  • Pricelist

    Show / Hide Table of Contents

    ValueAxis Class

    Namespace:
    GemBox.Spreadsheet.Charts
    Assembly:
    GemBox.Spreadsheet.dll

    Represents an axis used for series values.

    • C#
    • VB.NET
    public sealed class ValueAxis : ChartAxis
    Public NotInheritable Class ValueAxis
        Inherits ChartAxis
    Inheritance:
    System.Object
    ChartAxis
    ValueAxis

    Properties

    AxisType

    Gets the axis type for ValueAxis which is Value.

    • C#
    • VB.NET
    public override AxisType AxisType { get; }
    Public Overrides ReadOnly Property AxisType As AxisType
    Property Value
    AxisType

    The Value value.

    Overrides
    ChartAxis.AxisType

    MajorUnit

    Gets or sets the distance between major ticks or null if value should be automatically calculated based on chart's data.

    • C#
    • VB.NET
    public double? MajorUnit { get; set; }
    Public Property MajorUnit As Double?
    Property Value
    System.Nullable<System.Double>

    The distance between major ticks or null if value should be automatically calculated based on chart's data.

    Exceptions
    System.ArgumentOutOfRangeException

    Value is not positive number or is smaller than MinorUnit.

    Maximum

    Gets or sets the maximum value of the axis or null if value should be automatically calculated based on chart's data.

    • C#
    • VB.NET
    public double? Maximum { get; set; }
    Public Property Maximum As Double?
    Property Value
    System.Nullable<System.Double>

    The maximum value of the axis or null if value should be automatically calculated based on chart's data.

    Exceptions
    System.ArgumentOutOfRangeException

    Value is smaller than Minimum.

    Minimum

    Gets or sets the minimum value of the axis or null if value should be automatically calculated based on chart's data.

    • C#
    • VB.NET
    public double? Minimum { get; set; }
    Public Property Minimum As Double?
    Property Value
    System.Nullable<System.Double>

    The minimum value of the axis or null if value should be automatically calculated based on chart's data.

    Exceptions
    System.ArgumentOutOfRangeException

    Value is greater than Maximum.

    MinorUnit

    Gets or sets the distance between minor ticks or null if value should be automatically calculated based on chart's data.

    • C#
    • VB.NET
    public double? MinorUnit { get; set; }
    Public Property MinorUnit As Double?
    Property Value
    System.Nullable<System.Double>

    The distance between minor ticks or null if value should be automatically calculated based on chart's data.

    Exceptions
    System.ArgumentOutOfRangeException

    Value is not positive number or is greater than MajorUnit.

    Inherited Properties

    CrossType

    Gets or sets the axis cross configuration.

    (Inherited from ChartAxis)

    CrossesAt

    Gets or sets the specific value or category on which the opposite axis should be positioned. To be used with CrossType set to Specific.

    (Inherited from ChartAxis)

    Fill

    Gets or sets the fill formatting options.

    (Inherited from ChartAxis)

    IsVisible

    Gets or sets a value indicating whether axis is visible.

    (Inherited from ChartAxis)

    LabelsPosition

    Gets or sets the axis labels position.

    (Inherited from ChartAxis)

    MajorGridlines

    Gets the major gridlines.

    (Inherited from ChartAxis)

    MajorTickMarkType

    Gets or sets the major tick marks position.

    (Inherited from ChartAxis)

    MinorGridlines

    Gets the minor gridlines.

    (Inherited from ChartAxis)

    MinorTickMarkType

    Gets or sets the minor tick marks position.

    (Inherited from ChartAxis)

    NumberFormat

    Gets or sets the number format used for formatting axis value labels. If NumberFormatLinkedToSource is true, then number format from chart's source data (cells) will be used to format axis value labels as explained in remarks. Setting this property, sets NumberFormatLinkedToSource to false.

    (Inherited from ChartAxis)

    NumberFormatLinkedToSource

    Gets or sets a value indicating whether number format from chart's source data (cells) will be used to format axis value labels.

    (Inherited from ChartAxis)

    Outline

    Gets or sets the outline formatting options.

    (Inherited from ChartAxis)

    ReverseOrder

    Gets or sets a value indicating whether values on the axis shall be reversed so they go from maximum to minimum.

    This value is currently not supported when exporting a chart to PDF, XPS, or image formats. This value is always exported as false.

    (Inherited from ChartAxis)

    TextBoxFormat

    Gets or sets the text box formatting.

    (Inherited from ChartAxis)

    TextFormat

    Gets or sets the text formatting options.

    (Inherited from ChartAxis)

    Title

    Gets the axis title.

    (Inherited from ChartAxis)

    Inherited Methods

    ChangeAxisType(AxisType)

    Changes the type of the axis.

    (Inherited from ChartAxis)

    ChangeAxisType<TChartAxis>()

    Changes the type of the axis.

    (Inherited from ChartAxis)

    Delete()

    Deletes axis.

    (Inherited from ChartAxis)

    ToString()

    Returns a System.String that represents this ChartAxis instance.

    (Inherited from ChartAxis)

    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.