ExcelWriter Xojo Plugin

ExcelWriterSeries Class (console safe)

A class that represents series on Excel document.

This class has only private constructor so instances cannot be created directly. You can only get instances of this class from the ExcelWriterChart class by calling the X_Axis and Y_Axis properties.

Object
   ExcelWriterSeries

class ExcelWriterSeries

Constructors

ExcelWriterSeriesA private constructor that cannot be called.

Properties

InvertIfNegative (console safe) Inverts the fill color for negative values.
Smoothing (console safe) If set to true then the line gets smoothed

Methods

SetCategories (console safe) Assigns categories to the series.
SetFillProperties (console safe) Sets fill properties for the chart series.
SetLabelOptions (console safe) Determines what is shown when Labels are shown.
SetLabelsPercentage (console safe) Turns on displaying the labels for the series as percentage.
SetMarkerFillProperties (console safe) Set the fill properties of a chart marker
SetMarkerLineProperties (console safe) Set the line/border properties of a chart marker
SetMarkerSize (console safe) Sets the size of series markers.
SetMarkerType (console safe) Sets marker type for the series.
SetName (console safe) Sets name for the chart series.
SetNameRange (console safe) Links the name for the the chart series to a cell in the spreadsheet.
SetPoints (console safe) Sets custom series data point formatting
SetValues (console safe) Assigns values to the series.
ShowLabels (console safe) Turns on the data labels for the chart series.

Enumerations

MarkerTypeValuesA enum that defines series marker types.

Supported Platforms:

  • MacOS X Carbon
  • MacOS X Cocoa 32 bit
  • MacOS X Cocoa 64 bit
  • Windows 32 bit
  • Windows 64 bit
  • Linux 32 bit
  • Linux 64 bit
  • Linux ARM