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

ISparkAxes

Interface ISparkAxes

public interface ISparkAxes
Represents the settings for the horizontal and vertical axes of a group of sparklines.

Use this interface to access the axis settings associated with a sparkline group, including the ISparkHorizontalAxis and ISparkVerticalAxis objects.


 worksheet.getRange("A1:C1").setValue(new Object[] {1, 3, 2});
 ISparklineGroup sparklineGroup = worksheet.getRange("D1").getSparklineGroups().add(SparkType.Line, "A1:C1");
 ISparkAxes sparkAxes = sparklineGroup.getAxes();
 ISparkHorizontalAxis horizontalAxis = sparkAxes.getHorizontal();
 ISparkVerticalAxis verticalAxis = sparkAxes.getVertical();

  • Method Details

    • getHorizontal

      ISparkHorizontalAxis getHorizontal()
      Gets the ISparkHorizontalAxis object for this ISparkAxes object.

      Use the returned object to access and modify the horizontal axis settings of the sparkline group.

      
 worksheet.getRange("A1:A4").setValue(new Object[][] {{2}, {5}, {3}, {7}});
 ISparklineGroup group = worksheet.getRange("B1").getSparklineGroups().add(SparkType.Line, "A1:A4");
 ISparkHorizontalAxis horizontalAxis = group.getAxes().getHorizontal();
 horizontalAxis.setRightToLeftPlotOrder(true);
      Returns:
      The ISparkHorizontalAxis object that represents the horizontal axis settings of the sparkline group.

    • getVertical

      ISparkVerticalAxis getVertical()
      Gets the ISparkVerticalAxis object associated with this ISparkAxes object.

      Use the returned ISparkVerticalAxis object to access or modify the vertical axis settings for the sparkline group.

      
 worksheet.getRange("A1:A4").setValue(new Object[][] {{2}, {5}, {3}, {7}});
 ISparklineGroup group = worksheet.getRange("B1").getSparklineGroups().add(SparkType.Line, "A1:A4");
 ISparkVerticalAxis verticalAxis = group.getAxes().getVertical();
 verticalAxis.setMaxScaleType(SparkScale.SparkScaleGroup);
      Returns:
      The ISparkVerticalAxis object for the sparkline group.