Namespace EasyXLS.Charts

Class ExcelChart

System.Object

EasyXLS.Drawings.DrawingObject

EasyXLS.Drawings.LineDrawingObject

EasyXLS.Drawings.FillDrawingObject

EasyXLS.Drawings.DrawingObject2D

EasyXLS.Charts.ExcelChart

Direct Known Subclasses:

ExcelPivotChart

public class ExcelChart
extends DrawingObject2D

This class stores chart information like series, legend, axis, plot area, chart area, data table, title, series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.

Constructor Summary

Constructors

Constructor	Description
ExcelChart()	Defines an instance of the chart.
ExcelChart(int row, int column)	Defines an instance of the chart having the specified location This constructor is applicable only to adding charts to ExcelWorksheet objects
ExcelChart(int row, int column, int width, int height)	Defines an instance of the chart having the specified location and size This constructor is applicable only to adding charts to ExcelWorksheet objects
ExcelChart(System.String position)	Defines an instance of the chart having the specified location This constructor is applicable only to adding charts to ExcelWorksheet objects
ExcelChart(System.String position, int width, int height)	Defines an instance of the chart having the specified location and size This constructor is applicable only to adding charts to ExcelWorksheet objects

Method Summary

Modifier and Type	Method	Description
ExcelChart	Clone()	Creates and returns a copy of this object.
void	Dispose()	Disposes the allocated resources.
void	easy_addSeries(ExcelSeries xlsChartSeries)	Adds a new series to the chart.
void	easy_addSeries(System.String seriesName, System.String seriesValues)	Adds a new series to the chart. This method is overridden as easy_addSeries_2 in COM+ version of EasyXLS.
int	easy_get3DElevation()	Returns the 3D elevation setting of the chart.
int	easy_get3DHeight()	Returns the 3D height setting of the chart.
int	easy_get3DPerspective()	Returns the 3D perspective setting of the chart.
int	easy_get3DRotation()	Returns the 3D rotation setting of the chart.
ExcelAxis	easy_getCategoryXAxis()	Returns the chart category X axis.
System.String	easy_getCategoryXAxisLabels()	Returns the labels of category X axis.
ExcelChartArea	easy_getChartArea()	Returns the chart area.
ExcelDataTable	easy_getChartDataTable()	Returns the chart data table.
int	easy_getChartType()	Returns the type of the chart.
ExcelChartLegend	easy_getLegend()	Returns the chart legend.
ExcelPlotArea	easy_getPlotArea()	Returns the chart plot area.
ExcelSeries	easy_getSeriesAt(int index)	Returns the series from the specified index.
int	easy_getSeriesGap()	Returns the gap of the chart series.
int	easy_getSeriesOverlap()	Returns the overlap of the chart series.
System.String	easy_getTitle()	Deprecated. As of version 8.3, replaced by getChartTitle()
ExcelAxis	easy_getValueYAxis()	Returns the chart value Y axis.
ExcelChartGridlines	easy_getXAxisMajorGridlines()	Returns the style of the major gridlines for the X axis.
ExcelChartGridlines	easy_getXAxisMinorGridlines()	Returns the style of the minor gridlines for the X axis.
ExcelChartGridlines	easy_getYAxisMajorGridlines()	Returns the style of the major gridlines for the Y axis.
ExcelChartGridlines	easy_getYAxisMinorGridlines()	Returns the style of the minor gridlines for the Y axis.
void	easy_removeSeries(int index)	Removes the series from the specified index.
void	easy_set3DElevation(int n3DElevation)	Sets the 3D elevation setting of the chart.
void	easy_set3DHeight(int n3DHeight)	Sets the 3D height of the chart.
void	easy_set3DPerspective(int n3DPerspective)	Sets the 3D perspective of the chart.
void	easy_set3DRotation(int n3DRotation)	Sets the 3D rotation of the chart.
void	easy_setCategoryXAxis(ExcelAxis xlsCategoryXAxis)	Sets the chart category X axis.
void	easy_setCategoryXAxisLabels(System.String formulaCategoryXAxisLabels)	Sets the labels of category X axis.
void	easy_setChartArea(ExcelChartArea xlsChartArea)	Sets the chart area.
void	easy_setChartDataTable(ExcelDataTable xlsChartDataTable)	Sets the chart data table.
void	easy_setChartType(int chartType)	Sets the type of the chart.
void	easy_setLegend(ExcelChartLegend xlsLegend)	Sets the chart legend.
void	easy_setPlotArea(ExcelPlotArea xlsPlotArea)	Sets the chart plot area.
void	easy_setSeriesGap(int gap)	Sets the gap of the chart series.
void	easy_setSeriesOverlap(int overlap)	Sets the overlap of the chart series.
void	easy_setTitle(System.String title)	Deprecated. As of version 8.3, replaced by ExcelTitle.setText(System.String)
void	easy_setUse3DPerspective(bool use3DPerspective)	Sets if the 3D setting of the chart is used.
void	easy_setValueYAxis(ExcelAxis xlsValueYAxis)	Sets the chart value Y axis.
void	easy_setXAxisMajorGridlines(ExcelChartGridlines xlsGridlines)	Sets the style of the major gridlines for the X axis.
void	easy_setXAxisMinorGridlines(ExcelChartGridlines xlsGridlines)	Sets the style of the minor gridlines for the X axis.
void	easy_setYAxisMajorGridlines(ExcelChartGridlines xlsGridlines)	Sets the style of the major gridlines for the Y axis.
void	easy_setYAxisMinorGridlines(ExcelChartGridlines xlsGridlines)	Sets the style of the major gridlines for the Y axis.
bool	easy_Use3DPerspective()	Returns if the 3D perspective of the chart is used
int	getBubbleScale()	Returns the scale of the bubble size compared to chart in general.
int	getBubbleSize()	Returns if the scale represents the area of bubbles or the width of bubbles.
ExcelTitle	getChartTitle()	Returns the chart title.
int	getDoughnutHoleSize()	Returns the size of the doughnut hole.
FillFormat	getFillFormat()	Returns the fill format of the chart area.
int	getFirstSliceAngle()	Returns the angle of the first slice.
LineColorFormat	getLineColorFormat()	Returns the line color format of the chart area.
LineStyleFormat	getLineStyleFormat()	Returns the line style format of the chart area.
int	getPieExplosion()	Returns the pie explosion.
int	getSecondPlotSize()	Returns the size of the second plot.
ShadowFormat	getShadowFormat()	Returns the shadow format of the chart area.
int	getShowEmptyRowsAs()	Returns how the data points for the hidden cells are displayed for the chart series.
double	getSplitPosition()	Returns the split position, value or percentage value.
int	getSplitType()	Returns the split type.
int	getStyle()	Returns the chart style.
bool	HasVariableColorsBySlice()	Returns true if the color varies by slice.
int	SeriesCount()	Returns the number of series in the chart.
void	setBubbleScale(int percent)	Sets the scale of the bubble size compared to chart in general.
void	setBubbleSize(int bubbleSize)	Sets if the scale represents the area of bubbles or the width of bubbles.
void	setChartTitle(ExcelTitle xlsTitle)	Sets the chart title.
void	setDoughnutHoleSize(int size)	Sets the size of the doughnut hole.
void	setFirstSliceAngle(int angle)	Sets the angle of the first slice.
void	setPieExplosion(int distance)	Sets the pie explosion.
void	setSecondPlotSize(int size)	Sets the size of the second plot.
void	setShowDataInHiddenRowColumns(bool visible)	Sets if data in hidden rows and columns is visible.
void	setShowEmptyRows(int showAs)	Sets how the data points for the hidden cells are displayed for the chart series.
void	setShowNegativeBubbles(bool visible)	Sets if the negative bubbles are visible.
void	setStyle(int style)	Sets the style of the chart.
void	setVariableColorsBySlice(bool isVariableColor)	Sets the color of slices to be variable.
bool	ShowDataInHiddenRowColumns()	Returns true if data in hidden rows and columns is visible, false otherwise.
bool	ShowNegativeBubbles()	Returns true if the negative bubbles are visible, false otherwise.
void	splitSeriesByPercentageValue(int value)	Splits the series by a percentage value and sets that the second plot contains all values less than the specified percentage value.
void	splitSeriesByPosition(int values)	Splits the series by position and sets the number of last values for the second plot.
void	splitSeriesByValue(double value)	Splits the series by value and sets that the second plot contains all values less than the specified value.

Methods inherited from class EasyXLS.Drawings.DrawingObject2D

getLeftUpperCornerColumn, getLeftUpperCornerRow, setLeftUpperCorner, setLeftUpperCorner

Methods inherited from class EasyXLS.Drawings.FillDrawingObject

setFillFormat

Methods inherited from class EasyXLS.Drawings.LineDrawingObject

setLineColorFormat, setLineStyleFormat, setShadowFormat

Methods inherited from class EasyXLS.Drawings.DrawingObject

getHeight, getHorizontalOffset, getRelativeHeight, getRelativeHorizontalOffset, getRelativeVerticalOffset, getRelativeWidth, getVerticalOffset, getWidth, setLeftUpperOffset, setRelativeLeftUpperOffset, setRelativeSize, setSize

Methods inherited from class System.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ExcelChart

public ExcelChart()

Defines an instance of the chart.

ExcelChart

public ExcelChart(int row,
 int column)

Defines an instance of the chart having the specified location
This constructor is applicable only to adding charts to ExcelWorksheet objects

Parameters:

row - the row number where the left upper corner of the chart is anchored

column - the column number where the left upper corner of the chart is anchored

ExcelChart

public ExcelChart(int row,
 int column,
 int width,
 int height)

Defines an instance of the chart having the specified location and size
This constructor is applicable only to adding charts to ExcelWorksheet objects

Parameters:

row - the row number where the left upper corner of the chart is anchored

column - the column number where the left upper corner of the chart is anchored

width - the chart width

height - the chart height

ExcelChart

public ExcelChart(System.String position)

Defines an instance of the chart having the specified location
This constructor is applicable only to adding charts to ExcelWorksheet objects

Parameters:

position - the cell reference where the left upper corner of the chart is anchored

ExcelChart

public ExcelChart(System.String position,
 int width,
 int height)

Defines an instance of the chart having the specified location and size
This constructor is applicable only to adding charts to ExcelWorksheet objects

Parameters:

position - the cell reference where the left upper corner of the chart is anchored

width - the chart width

height - the chart height

Method Details

easy_setChartType

public void easy_setChartType(int chartType)

Sets the type of the chart. Possible values are available in Chart class.

Parameters:

chartType - the type of the chart

See Also:

easy_getChartType()

easy_getChartType

public int easy_getChartType()

Returns the type of the chart. Possible values are available in Chart class.

Returns:

the type of the chart

See Also:

easy_setChartType(int)

easy_addSeries

public void easy_addSeries(ExcelSeries xlsChartSeries)

Adds a new series to the chart.

Parameters:

xlsChartSeries - - the chart series

See Also:

easy_removeSeries(int), easy_getSeriesAt(int), SeriesCount()

easy_addSeries

public void easy_addSeries(System.String seriesName,
 System.String seriesValues)

Adds a new series to the chart.
This method is overridden as easy_addSeries_2 in COM+ version of EasyXLS.

Parameters:

seriesName - - the series name.

seriesValues - - the series values.

See Also:

easy_removeSeries(int), easy_getSeriesAt(int), SeriesCount()

easy_removeSeries

public void easy_removeSeries(int index)

Removes the series from the specified index.

Parameters:

index - the series index

See Also:

easy_addSeries(EasyXLS.Charts.ExcelSeries), easy_getSeriesAt(int), SeriesCount()

easy_getSeriesAt

public ExcelSeries easy_getSeriesAt(int index)

Returns the series from the specified index.

Parameters:

index - the series index

Returns:

the series with the specified index

See Also:

easy_addSeries(EasyXLS.Charts.ExcelSeries), easy_removeSeries(int), SeriesCount()

SeriesCount

public int SeriesCount()

Returns the number of series in the chart.

Returns:

the number of series in the chart

See Also:

easy_addSeries(EasyXLS.Charts.ExcelSeries), easy_removeSeries(int), easy_getSeriesAt(int)

easy_setCategoryXAxisLabels

public void easy_setCategoryXAxisLabels(System.String formulaCategoryXAxisLabels)

Sets the labels of category X axis. It must be a formula.

Parameters:

formulaCategoryXAxisLabels - the labels of category X axis

See Also:

easy_getCategoryXAxisLabels()

easy_getCategoryXAxisLabels

public System.String easy_getCategoryXAxisLabels()

Returns the labels of category X axis.

Returns:

the labels of category X axis

See Also:

easy_setCategoryXAxisLabels(System.String)

easy_setTitle

public void easy_setTitle(System.String title)

Deprecated.

As of version 8.3, replaced by ExcelTitle.setText(System.String)

Sets the chart title.

Parameters:

title - the chart title

See Also:

easy_getTitle()

easy_getTitle

public System.String easy_getTitle()

Deprecated.

As of version 8.3, replaced by getChartTitle()

Returns the chart title.

Returns:

the chart title

See Also:

easy_setTitle(System.String)

setChartTitle

public void setChartTitle(ExcelTitle xlsTitle)

Sets the chart title.

Parameters:

xlsTitle - the chart title

See Also:

getChartTitle()

getChartTitle

public ExcelTitle getChartTitle()

Returns the chart title.

Returns:

the chart title

See Also:

setChartTitle(EasyXLS.Charts.ExcelTitle)

easy_getChartArea

public ExcelChartArea easy_getChartArea()

Returns the chart area.

Returns:

the chart area

See Also:

easy_setChartArea(EasyXLS.Charts.ExcelChartArea)

easy_setChartArea

public void easy_setChartArea(ExcelChartArea xlsChartArea)

Sets the chart area.

Parameters:

xlsChartArea - the chart area.

See Also:

easy_getChartArea()

getFillFormat

public FillFormat getFillFormat()

Returns the fill format of the chart area.

Overrides:

getFillFormat in class FillDrawingObject

Returns:

the fill format of the chart area

See Also:

FillDrawingObject.setFillFormat(EasyXLS.Drawings.Formatting.FillFormat)

getLineColorFormat

public LineColorFormat getLineColorFormat()

Returns the line color format of the chart area.

Overrides:

getLineColorFormat in class LineDrawingObject

Returns:

the line color format of the chart area

See Also:

LineDrawingObject.setLineColorFormat(EasyXLS.Drawings.Formatting.LineColorFormat)

getLineStyleFormat

public LineStyleFormat getLineStyleFormat()

Returns the line style format of the chart area.

Overrides:

getLineStyleFormat in class LineDrawingObject

Returns:

the line style format of the chart area

See Also:

LineDrawingObject.setLineStyleFormat(EasyXLS.Drawings.Formatting.LineStyleFormat)

getShadowFormat

public ShadowFormat getShadowFormat()

Returns the shadow format of the chart area.

Overrides:

getShadowFormat in class LineDrawingObject

Returns:

the shadow format of the chart area

See Also:

LineDrawingObject.setShadowFormat(EasyXLS.Drawings.Formatting.ShadowFormat)

easy_getPlotArea

public ExcelPlotArea easy_getPlotArea()

Returns the chart plot area.

Returns:

the chart plot area

See Also:

easy_setPlotArea(EasyXLS.Charts.ExcelPlotArea)

easy_setPlotArea

public void easy_setPlotArea(ExcelPlotArea xlsPlotArea)

Sets the chart plot area.

Parameters:

xlsPlotArea - the chart plot area

See Also:

easy_getPlotArea()

easy_getLegend

public ExcelChartLegend easy_getLegend()

Returns the chart legend.

Returns:

the chart legend

See Also:

easy_setLegend(EasyXLS.Charts.ExcelChartLegend)

easy_setLegend

public void easy_setLegend(ExcelChartLegend xlsLegend)

Sets the chart legend.

Parameters:

xlsLegend - the chart legend

See Also:

easy_getLegend()

easy_getCategoryXAxis

public ExcelAxis easy_getCategoryXAxis()

Returns the chart category X axis.

Returns:

the chart category X axis

See Also:

easy_setCategoryXAxis(EasyXLS.Charts.ExcelAxis)

easy_setCategoryXAxis

public void easy_setCategoryXAxis(ExcelAxis xlsCategoryXAxis)

Sets the chart category X axis.

Parameters:

xlsCategoryXAxis - the chart category X axis

See Also:

easy_getCategoryXAxis()

easy_setValueYAxis

public void easy_setValueYAxis(ExcelAxis xlsValueYAxis)

Sets the chart value Y axis.

Parameters:

xlsValueYAxis - the chart value Y axis

See Also:

easy_getValueYAxis()

easy_getValueYAxis

public ExcelAxis easy_getValueYAxis()

Returns the chart value Y axis.

Returns:

the chart value Y axis

See Also:

easy_setValueYAxis(EasyXLS.Charts.ExcelAxis)

easy_setXAxisMajorGridlines

public void easy_setXAxisMajorGridlines(ExcelChartGridlines xlsGridlines)

Sets the style of the major gridlines for the X axis.

Parameters:

xlsGridlines - the style of the major gridlines for the X axis

See Also:

easy_getXAxisMajorGridlines(), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMajorGridlines(), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMinorGridlines(), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMinorGridlines()

easy_getXAxisMajorGridlines

public ExcelChartGridlines easy_getXAxisMajorGridlines()

Returns the style of the major gridlines for the X axis.

Returns:

the style of the major gridlines for the X axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMajorGridlines(), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMinorGridlines(), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMinorGridlines()

easy_setYAxisMajorGridlines

public void easy_setYAxisMajorGridlines(ExcelChartGridlines xlsGridlines)

Sets the style of the major gridlines for the Y axis.

Parameters:

xlsGridlines - the style of the major gridlines for the Y axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMajorGridlines(), easy_getYAxisMajorGridlines(), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMinorGridlines(), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMinorGridlines()

easy_getYAxisMajorGridlines

public ExcelChartGridlines easy_getYAxisMajorGridlines()

Returns the style of the major gridlines for the Y axis.

Returns:

the style of the major gridlines for the Y axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMajorGridlines(), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMinorGridlines(), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMinorGridlines()

easy_setXAxisMinorGridlines

public void easy_setXAxisMinorGridlines(ExcelChartGridlines xlsGridlines)

Sets the style of the minor gridlines for the X axis.

Parameters:

xlsGridlines - the style of the minor gridlines for the X axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMajorGridlines(), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMajorGridlines(), easy_getXAxisMinorGridlines(), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMinorGridlines()

easy_getXAxisMinorGridlines

public ExcelChartGridlines easy_getXAxisMinorGridlines()

Returns the style of the minor gridlines for the X axis.

Returns:

the style of the minor gridlines for the X axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMajorGridlines(), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMajorGridlines(), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMinorGridlines()

easy_setYAxisMinorGridlines

public void easy_setYAxisMinorGridlines(ExcelChartGridlines xlsGridlines)

Sets the style of the major gridlines for the Y axis.

Parameters:

xlsGridlines - the style of the major gridlines for the Y axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMajorGridlines(), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMajorGridlines(), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMinorGridlines(), easy_getYAxisMinorGridlines()

easy_getYAxisMinorGridlines

public ExcelChartGridlines easy_getYAxisMinorGridlines()

Returns the style of the minor gridlines for the Y axis.

Returns:

the style of the minor gridlines for the Y axis

See Also:

easy_setXAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMajorGridlines(), easy_setYAxisMajorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getYAxisMajorGridlines(), easy_setXAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines), easy_getXAxisMinorGridlines(), easy_setYAxisMinorGridlines(EasyXLS.Charts.ExcelChartGridlines)

easy_setChartDataTable

public void easy_setChartDataTable(ExcelDataTable xlsChartDataTable)

Sets the chart data table.

Parameters:

xlsChartDataTable - the chart data table

See Also:

easy_getChartDataTable()

easy_getChartDataTable

public ExcelDataTable easy_getChartDataTable()

Returns the chart data table.

Returns:

the chart data table

See Also:

easy_setChartDataTable(EasyXLS.Charts.ExcelDataTable)

easy_setSeriesOverlap

public void easy_setSeriesOverlap(int overlap)

Sets the overlap of the chart series.

Parameters:

overlap - the overlap of the chart series

See Also:

easy_getSeriesOverlap(), easy_setSeriesGap(int), easy_getSeriesGap()

easy_getSeriesOverlap

public int easy_getSeriesOverlap()

Returns the overlap of the chart series.

Returns:

the overlap of the chart series

See Also:

easy_setSeriesOverlap(int), easy_setSeriesGap(int), easy_getSeriesGap()

easy_setSeriesGap

public void easy_setSeriesGap(int gap)

Sets the gap of the chart series.

Parameters:

gap - the gap of the chart series

See Also:

easy_getSeriesGap(), easy_setSeriesOverlap(int), easy_getSeriesOverlap()

easy_getSeriesGap

public int easy_getSeriesGap()

Returns the gap of the chart series.

Returns:

the gap of the chart series

See Also:

easy_setSeriesGap(int), easy_setSeriesOverlap(int), easy_getSeriesOverlap()

easy_set3DRotation

public void easy_set3DRotation(int n3DRotation)

Sets the 3D rotation of the chart.

Parameters:

n3DRotation - the 3D rotation of the chart

See Also:

easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DHeight(int), easy_get3DHeight(), easy_set3DPerspective(int), easy_get3DPerspective(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_get3DRotation

public int easy_get3DRotation()

Returns the 3D rotation setting of the chart.

Returns:

the 3D rotation of the chart

See Also:

easy_set3DRotation(int), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DHeight(int), easy_get3DHeight(), easy_set3DPerspective(int), easy_get3DPerspective(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_set3DElevation

public void easy_set3DElevation(int n3DElevation)

Sets the 3D elevation setting of the chart.

Parameters:

n3DElevation - the 3D elevation setting of the chart

See Also:

easy_get3DElevation(), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DHeight(int), easy_get3DHeight(), easy_set3DPerspective(int), easy_get3DPerspective(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_get3DElevation

public int easy_get3DElevation()

Returns the 3D elevation setting of the chart.

Returns:

the 3D elevation setting of the chart

See Also:

easy_set3DElevation(int), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DHeight(int), easy_get3DHeight(), easy_set3DPerspective(int), easy_get3DPerspective(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_set3DHeight

public void easy_set3DHeight(int n3DHeight)

Sets the 3D height of the chart.

Parameters:

n3DHeight - the 3D height of the chart

See Also:

easy_get3DHeight(), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DPerspective(int), easy_get3DPerspective(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_get3DHeight

public int easy_get3DHeight()

Returns the 3D height setting of the chart.

Returns:

the 3D height of the chart

See Also:

easy_set3DHeight(int), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DPerspective(int), easy_get3DPerspective(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_set3DPerspective

public void easy_set3DPerspective(int n3DPerspective)

Sets the 3D perspective of the chart.

Parameters:

n3DPerspective - the 3D perspective of the chart

See Also:

easy_get3DPerspective(), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DHeight(int), easy_get3DHeight(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_get3DPerspective

public int easy_get3DPerspective()

Returns the 3D perspective setting of the chart.

Returns:

the 3D perspective of the chart

See Also:

easy_set3DPerspective(int), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DHeight(int), easy_get3DHeight(), easy_setUse3DPerspective(bool), easy_Use3DPerspective()

easy_setUse3DPerspective

public void easy_setUse3DPerspective(bool use3DPerspective)

Sets if the 3D setting of the chart is used.

Parameters:

use3DPerspective - true if the 3D setting is used, false otherwise

See Also:

easy_Use3DPerspective(), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DHeight(int), easy_get3DHeight(), easy_set3DPerspective(int), easy_get3DPerspective()

easy_Use3DPerspective

public bool easy_Use3DPerspective()

Returns if the 3D perspective of the chart is used

Returns:

true if the 3D perspective of the chart is used, false otherwise

See Also:

easy_setUse3DPerspective(bool), easy_set3DRotation(int), easy_get3DRotation(), easy_set3DElevation(int), easy_get3DElevation(), easy_set3DHeight(int), easy_get3DHeight(), easy_set3DPerspective(int), easy_get3DPerspective()

setFirstSliceAngle

public void setFirstSliceAngle(int angle)

Sets the angle of the first slice. It is valid only for pie and doughnut charts.

Parameters:

angle - the angle of the first slice

See Also:

getFirstSliceAngle()

getFirstSliceAngle

public int getFirstSliceAngle()

Returns the angle of the first slice. It is valid only for pie and doughnut charts.

Returns:

the angle of the first slice

See Also:

setFirstSliceAngle(int)

setVariableColorsBySlice

public void setVariableColorsBySlice(bool isVariableColor)

Sets the color of slices to be variable. It is valid only for pie and doughnut charts.

Parameters:

isVariableColor - true if the color varies by slice

See Also:

HasVariableColorsBySlice()

HasVariableColorsBySlice

public bool HasVariableColorsBySlice()

Returns true if the color varies by slice. It is valid only for pie and doughnut charts.

Returns:

true if the color varies by slice

See Also:

setVariableColorsBySlice(bool)

setPieExplosion

public void setPieExplosion(int distance)

Sets the pie explosion. It is valid only for pie charts.

Parameters:

distance - the pie explosion

See Also:

getFirstSliceAngle()

getPieExplosion

public int getPieExplosion()

Returns the pie explosion. It is valid only for pie charts.

Returns:

the pie explosion

See Also:

setPieExplosion(int)

splitSeriesByPosition

public void splitSeriesByPosition(int values)

Splits the series by position and sets the number of last values for the second plot. It is valid only for pie of pie and bar of pie charts.

Parameters:

values - the number of values for the second plot

See Also:

getSplitPosition(), splitSeriesByValue(double), splitSeriesByPercentageValue(int)

splitSeriesByValue

public void splitSeriesByValue(double value)

Splits the series by value and sets that the second plot contains all values less than the specified value. It is valid only for pie of pie and bar of pie charts.

Parameters:

value - the maximum value contained by the second plot

See Also:

getSplitPosition(), splitSeriesByPosition(int), splitSeriesByPercentageValue(int)

splitSeriesByPercentageValue

public void splitSeriesByPercentageValue(int value)

Splits the series by a percentage value and sets that the second plot contains all values less than the specified percentage value. It is valid only for pie of pie and bar of pie charts.

Parameters:

value - the maximum percentage value contained by the second plot

See Also:

getSplitPosition(), splitSeriesByPosition(int), splitSeriesByValue(double)

getSplitPosition

public double getSplitPosition()

Returns the split position, value or percentage value. It is valid only for pie of pie and bar of pie charts.

Returns:

the split position, value or percentage value

See Also:

splitSeriesByPosition(int), splitSeriesByValue(double), splitSeriesByPercentageValue(int)

getSplitType

public int getSplitType()

Returns the split type. It is valid only for pie of pie and bar of pie charts.

Returns:

the split type. Possible values are available in Chart class.

See Also:

splitSeriesByPosition(int), splitSeriesByValue(double), splitSeriesByPercentageValue(int)

setSecondPlotSize

public void setSecondPlotSize(int size)

Sets the size of the second plot. It is valid only for pie of pie and bar of pie charts.

Parameters:

size - the size of the second plot

See Also:

getSecondPlotSize()

getSecondPlotSize

public int getSecondPlotSize()

Returns the size of the second plot. It is valid only for pie of pie and bar of pie charts.

Returns:

the the size of the second plot

See Also:

setSecondPlotSize(int)

setDoughnutHoleSize

public void setDoughnutHoleSize(int size)

Sets the size of the doughnut hole. It is valid only for doughnut charts.

Parameters:

size - the size of the doughnut hole

See Also:

getDoughnutHoleSize()

getDoughnutHoleSize

public int getDoughnutHoleSize()

Returns the size of the doughnut hole. It is valid only for doughnut charts.

Returns:

the size of the doughnut hole

See Also:

setDoughnutHoleSize(int)

setBubbleScale

public void setBubbleScale(int percent)

Sets the scale of the bubble size compared to chart in general. It is valid only for bubble charts.

Parameters:

percent - the scale of the bubble size

See Also:

getBubbleScale()

getBubbleScale

public int getBubbleScale()

Returns the scale of the bubble size compared to chart in general. It is valid only for bubble charts.

Returns:

the scale of the bubble size

See Also:

setBubbleScale(int)

setBubbleSize

public void setBubbleSize(int bubbleSize)

Sets if the scale represents the area of bubbles or the width of bubbles. It is valid only for bubble charts. Possible values are available in Chart class.

Parameters:

bubbleSize - the area of bubbles or the width of bubbles

See Also:

getBubbleSize()

getBubbleSize

public int getBubbleSize()

Returns if the scale represents the area of bubbles or the width of bubbles. It is valid only for bubble charts. Possible values are available in Chart class.

Returns:

if the scale represents the area of bubbles or the width of bubbles

See Also:

setBubbleSize(int)

setShowNegativeBubbles

public void setShowNegativeBubbles(bool visible)

Sets if the negative bubbles are visible. It is valid only for bubble charts.

Parameters:

visible - true if the negative bubbles are visible, false otherwise

See Also:

HasVariableColorsBySlice()

ShowNegativeBubbles

public bool ShowNegativeBubbles()

Returns true if the negative bubbles are visible, false otherwise. It is valid only for bubble charts.

Returns:

true if the negative bubbles are visible, false otherwise

See Also:

setShowNegativeBubbles(bool)

getStyle

public int getStyle()

Returns the chart style.

Returns:

the chart style

See Also:

setStyle(int)

setStyle

public void setStyle(int style)

Sets the style of the chart. There are 48 predefined styles.

Parameters:

style - the style of the chart

See Also:

getStyle()

getShowEmptyRowsAs

public int getShowEmptyRowsAs()

Returns how the data points for the hidden cells are displayed for the chart series. Possible values are available in Chart class.

Returns:

how the data points for the hidden cells are displayed for the chart series

See Also:

setShowEmptyRows(int)

setShowEmptyRows

public void setShowEmptyRows(int showAs)

Sets how the data points for the hidden cells are displayed for the chart series. Possible values are available in Chart class.

Parameters:

showAs - how the data points for the hidden cells are displayed for the chart series

See Also:

getShowEmptyRowsAs()

setShowDataInHiddenRowColumns

public void setShowDataInHiddenRowColumns(bool visible)

Sets if data in hidden rows and columns is visible.

Parameters:

visible - true if data in hidden rows and columns is visible, false otherwise

See Also:

ShowDataInHiddenRowColumns()

ShowDataInHiddenRowColumns

public bool ShowDataInHiddenRowColumns()

Returns true if data in hidden rows and columns is visible, false otherwise.

Returns:

true if data in hidden rows and columns is visible, false otherwise

See Also:

setShowDataInHiddenRowColumns(bool)

Dispose

public void Dispose()

Disposes the allocated resources.

Clone

public ExcelChart Clone()

Creates and returns a copy of this object.

Returns:

a clone of this instance.