[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

TrendlineType

Enum Class TrendlineType

java.lang.Object
java.lang.Enum<TrendlineType>
com.grapecity.documents.excel.drawing.TrendlineType
All Implemented Interfaces:
Serializable, Comparable<TrendlineType>, Constable
public enum TrendlineType extends Enum<TrendlineType>
Specifies how a chart trendline is calculated.

Use this enum with ITrendline.setType(TrendlineType) to choose the mathematical model used to fit a trendline to a data series, such as linear, logarithmic, polynomial, power, exponential, or moving-average analysis.


 worksheet.getRange("A1:B5").setValue(new Object[][] {
     {"Month", "Sales"}, {"Jan", 10}, {"Feb", 15}, {"Mar", 18}, {"Apr", 24}
 });
 IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 20, 20, 300, 200);
 shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B5"), RowCol.Columns, true, true);
 ITrendline trendline = shape.getChart().getSeriesCollection().get(0).getTrendlines().add();
 trendline.setType(TrendlineType.Linear);

  • Nested Class Summary

    Nested classes/interfaces inherited from class java.lang.Enum

    Enum.EnumDesc<E extends Enum<E>>

  • Enum Constant Summary

    Enum Constants
    Enum Constant
    Description
    Exponential
    Uses an equation y=ab^x to calculate that the least squares fit through points.
    Linear
    Uses the linear equation y = mx + b to calculate that the least squares fit through points.
    Logarithmic
    Uses the equation y = c ln x + b to calculate that the least squares fit through points.
    MovingAvg
    Uses a sequence of averages computed from parts of the data series.
    Polynomial
    Uses an equation y = ax^6 + bx^5 + cx^4 + dx^3 + ex^2 + fx + g to calculate that the least squares fit through points.
    Power
    Uses an equation y = ax^b to calculate that the least squares fit through points.

  • Method Summary

    Modifier and Type
    Method
    Description
    static TrendlineType
    valueOf(String name)
    Returns the enum constant of this class with the specified name.
    static TrendlineType[]
    values()
    Returns an array containing the constants of this enum class, in the order they are declared.

    Methods inherited from class java.lang.Enum

    clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

    Methods inherited from class java.lang.Object

    getClass, notify, notifyAll, wait, wait, wait

  • Enum Constant Details

    • Logarithmic

      public static final TrendlineType Logarithmic
      Uses the equation y = c ln x + b to calculate that the least squares fit through points.

    • Linear

      public static final TrendlineType Linear
      Uses the linear equation y = mx + b to calculate that the least squares fit through points.

    • Polynomial

      public static final TrendlineType Polynomial
      Uses an equation y = ax^6 + bx^5 + cx^4 + dx^3 + ex^2 + fx + g to calculate that the least squares fit through points.

    • Power

      public static final TrendlineType Power
      Uses an equation y = ax^b to calculate that the least squares fit through points.

    • Exponential

      public static final TrendlineType Exponential
      Uses an equation y=ab^x to calculate that the least squares fit through points.

    • MovingAvg

      public static final TrendlineType MovingAvg
      Uses a sequence of averages computed from parts of the data series. The number of points equals the total number of points in the series less the number specified for the period.

  • Method Details

    • values

      public static TrendlineType[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static TrendlineType valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null