ExcelWriter Xojo Plugin

ExcelWriterChart Class (console safe)

A class that represents a Excel chart.

This class has only private constructor so instances cannot be created directly. To create instance of this class you call the AddChart function on the ExcelWriterWorkbook class.

Object
   ExcelWriterChart

class ExcelWriterChart

Constructors

ExcelWriterChartA private constructor that cannot be called.

Properties

DoughnutHoleSize (console safe) Sets the hole size for doughnut charts in percentage.
Rotation (console safe) Sets the rotation of segments in Pie and Doughnut charts in degrees.
StyleNumber (console safe) Set the style of the chart to one of the 48 built-in styles available on the "Design" tab in Excel 2007.
TitleVisible (console safe) Set or gets the charts title visibility.
X_Axis (console safe) Returns the X_Axis object of the chart.
Y_Axis (console safe) Returns the Y_Axis object of the chart.

Methods

AddSeries (console safe) Adds data series to chart and returns ExcelWriterSeries object.
AddSeries (console safe) Adds data series with values to chart and returns ExcelWriterSeries object.
AddSeries (console safe) Adds data series with categories and values to chart and returns ExcelWriterSeries object.
ChartAreaSetFillProperties (console safe) Sets the fill properties for the area behind the chart.
ChartAreaSetLineProperties (console safe) Sets the line properties for the area behind the chart.
ChartAreaSetPattern (console safe) Sets pattern for the area behind the chart.
HideSpecificSeries (console safe) Hides specific series by index from the chart.
PlotAreaSetFillProperties (console safe) Sets the fill properties for the plot area.
PlotAreaSetLineProperties (console safe) Sets the line properties for the plot area.
PlotAreaSetPattern (console safe) Sets pattern for the plot area of the chart.
SetLegendFont (console safe) Sets font and style of the legend.
SetLegendPosition (console safe) Sets the position of the Legend.
SetName (console safe) Sets title of the chart, this can be string or formula.
SetNameFont (console safe) Sets the font and style of the Title of the chart.
SetNameRange (console safe) Sets title of the chart by pointing to cell in a given sheet.
ShowTable (console safe) Adds a data table below the horizontal axis with the data used to plot the chart

Enumerations

ChartTypeValuesA enum that defines types of charts that can be created.
LegendPositionValuesA enum that defines positions for the Legend

Chart Limitations

The following chart features aren't currently supported in libxlsxwriter which is used under the hood in this Xojo plugin:

Chart formatting.
Chart markers.
Secondary axis.
Combined charts.
Chart legend formatting.
Chart area and plot area formatting.
Chart tables.
Up down lines.
Drop boxes.

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