XlsChart

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.spire.xls.core.spreadsheet.charts
Class XlsChart

java.lang.Object
  com.spire.xls.core.spreadsheet.XlsObject
      com.spire.xls.core.spreadsheet.XlsWorksheetBase
          com.spire.xls.core.spreadsheet.charts.XlsChart

All Implemented Interfaces:: IChart

Direct Known Subclasses:: ChartSheet

public class XlsChart
extends XlsWorksheetBase
implements IChart
extends XlsWorksheetBase
implements IChart

Constructor Summary
`XlsChart(java.lang.Object parent)`

Method Summary
`boolean`	`canChartBubbleLabel()` Returns True if chart can have bubble data labels.
`boolean`	`canChartHaveSeriesLines()` Returns True if chart can have series lines.
`boolean`	`canChartPercentageLabel()` Returns True if chart can have percentage data labels.
`boolean`	`checkForSupportGridLine()` Chacks for existing gridlines in chart.
`XlsChart`	`deepClone(java.util.HashMap hashNewNames, java.lang.Object parent, java.util.HashMap dicFontIndexes)` Clones current instance.
`java.lang.Object`	`deepClone(java.lang.Object parent)` Clones current instance.
`boolean`	`getAutoScaling()` True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.
`java.lang.String`	`getCategoryAxisTitle()` Title of the category axis.
`IChartFrameFormat`	`getChartArea()` Returns an object that represents the complete chart area for the chart.
`java.lang.String`	`getChartStartType()` Returns start type of chart type.
`java.lang.String`	`getChartTitle()` Title of the chart.
`IFont`	`getChartTitleFont()` Returns object that describes chart title area.
`ExcelChartType`	`getChartType()` Type of the chart.
`IXLSRange`	`getDataRange()` DataRange for the chart series.
`IChartDataTable`	`getDataTable()` Represents charts dataTable object.
`ChartLinePatternType`	`getDefaultLinePattern()` Returns default line pattern for the chart.
`int`	`getDepthPercent()` Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
`ExcelChartType`	`getDestinationType()` Gets chart type after type change.
`boolean`	`getDisplayAxisFieldButtons()` Gets or sets a value indicating whether [show axis field buttons].
`ChartPlotEmptyType`	`getDisplayBlanksAs()` Represents the way that blank cells are plotted on a chart.
`boolean`	`getDisplayEntireFieldButtons()` Gets or sets a value indicating whether [show all field buttons].
`boolean`	`getDisplayLegendFieldButtons()` Gets or sets a value indicating whether [show legend field buttons].
`boolean`	`getDisplayValueFieldButtons()` Gets or sets a value indicating whether [show value field buttons].
`int`	`getElevation()` Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).
`IChartWallOrFloor`	`getFloor()` Represents chart floor.
`FontWrapper`	`getFont()` Gets font which used for displaying axis text .
`int`	`getGapDepth()` Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )
`double`	`getHeight()` Height of the chart in points (1/72 inch).
`int`	`getHeightPercent()` Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
`IChartLegend`	`getLegend()` Represents chart legend.
`boolean`	`getNeedDataFormat()` Returns True if chart needs data format to be saved.
`boolean`	`getNeedDropBar()` Returns True if chart needs drop bars to be saved.
`boolean`	`getNeedMarkerFormat()` Returns True if chart needs marker format to be saved.
`boolean`	`getNoPlotArea()` Returns True if chart has no plot area.
`IChartPageSetup`	`getPageSetup()` Page setup for the chart.
`int`	`getPerspective()` Returns or sets the perspective for the 3-D chart view (0 to 100).
`ExcelChartType`	`getPivotChartType()` Gets or sets the type of the pivot chart.
`PivotTable`	`getPivotTable()` Gets or sets the pivot source.
`IChartFrameFormat`	`getPlotArea()` Returns plot area frame format.
`boolean`	`getPlotVisibleOnly()` True if only visible cells are plotted.
`IChartCategoryAxis`	`getPrimaryCategoryAxis()` Primary category axis.
`IChartSeriesAxis`	`getPrimarySerieAxis()` Primary serie axis.
`IChartValueAxis`	`getPrimaryValueAxis()` Primary value axis.
`boolean`	`getRightAngleAxes()` True if the chart axes are at right angles, independent of chart rotation or elevation.
`int`	`getRotation()` Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees).
`IChartCategoryAxis`	`getSecondaryCategoryAxis()` Secondary category axis.
`java.lang.String`	`getSecondaryCategoryAxisTitle()` Title of the secondary category axis.
`IChartValueAxis`	`getSecondaryValueAxis()` Secondary value axis.
`java.lang.String`	`getSecondaryValueAxisTitle()` Title of the secondary value axis.
`java.lang.String`	`getSeriesAxisTitle()` Title of the series axis.
`boolean`	`getSeriesDataFromRange()` True if series are in rows in DataRange; False otherwise.
`boolean`	`getShowReportFilterFieldButtons()` Gets or sets a value indicating whether [show report filter field buttons].
`boolean`	`getSizeWithWindow()` True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
`int`	`getStyle()` Style index for Excel 2007 chart.
`boolean`	`getSupportWallsAndFloor()` Indicates whether this chart supports walls and floor.
`java.lang.String`	`getValueAxisTitle()` Title of the value axis.
`IChartWallOrFloor`	`getWalls()` Represents chart walls.
`boolean`	`getWallsAndGridlines2D()` True if gridlines are drawn two-dimensionally on a 3-D chart.
`double`	`getWidth()` Width of the chart in points (1/72 inch).
`double`	`getXPos()` X coordinate of the upper-left corner of the chart in points (1/72 inch).
`double`	`getYPos()` Y coordinate of the upper-left corner of the chart in points (1/72 inch).
`boolean`	`getZoomToFit()` Gets or sets zoomToFit value.
`boolean`	`hasChartArea()` Indicates whether chart has chart area.
`void`	`hasChartArea(boolean value)` Indicates whether chart has chart area.
`boolean`	`hasChartTitle()` Indicates wheather the chart has title
`boolean`	`hasDataTable()` True if the chart has a data table.
`void`	`hasDataTable(boolean value)` True if the chart has a data table.
`boolean`	`hasFloor()` Gets value indicating whether floor object was created.
`boolean`	`hasLegend()` True if the chart has a legend object.
`void`	`hasLegend(boolean value)` True if the chart has a legend object.
`boolean`	`hasPivotTable()` Indicates whether contains pivot table.
`boolean`	`hasPlotArea()` Indicates whether chart has plot area.
`void`	`hasPlotArea(boolean value)` Indicates whether chart has plot area.
`boolean`	`hasWalls()` Gets value indicating whether floor object was created.
`boolean`	`isCategoryAxisAvail()` Indicates whether chart has a category axis.
`boolean`	`isChart_100()` Returns True if chart is 100%.
`boolean`	`isChart3D()` Returns True if chart is 3D.
`boolean`	`isChartBar()` Returns True if chart is a bar chart.
`boolean`	`isChartBubble()` Returns True if chart is a bubble chart.
`boolean`	`isChartCone()` Returns True if chart is a conical shape.
`boolean`	`isChartCylinder()` Returns True if chart is a cylinder shape.
`boolean`	`isChartDoughnut()` Returns True if chart is a doughnut chart.
`boolean`	`isChartExploded()` Returns True if chart is exploded.
`boolean`	`isChartFloor()` Returns True if chart has floor.
`boolean`	`isChartLine()` Returns True if chart is line.
`boolean`	`isChartPie()` Returns True if chart is a pie chart.
`boolean`	`isChartPyramid()` Returns True if chart is a pyramid shape.
`boolean`	`isChartRadar()` Returns True if chart is a radar chart.
`boolean`	`isChartScatter()` Returns True if chart is a scatter chart.
`boolean`	`isChartSmoothedLine()` Returns True if chart has smoothed lines.
`boolean`	`isChartStock()` Returns True if this is a stock chart.
`boolean`	`isChartVeryColor()` Returns True if chart should have a different color for each series value.
`boolean`	`isChartVolume()` Returns True if chart is a stock chart with volume.
`boolean`	`isChartWalls()` Returns True if chart has walls.
`boolean`	`isClustered()` Returns True if chart is a clustered chart.
`boolean`	`isEmbeded()` Gets value indicating whether chart is embeded into worksheet.
`boolean`	`isPerspective()` Returns True if chart has perspective.
`boolean`	`isPivot3DChart()` Gets a value indicating whether this instance is pivot 3D chart .
`boolean`	`isSecondaryAxes()` Returns True if at least one of the secondary axes is present.
`void`	`isSecondaryAxes(boolean value)` Returns True if at least one of the secondary axes is present.
`boolean`	`isSeriesLines()` Returns True if chart has series lines.
`boolean`	`isSpecialDataLabels()` Returns True if chart needs special data labels serialization.
`boolean`	`isStacked()` Returns True if chart is stacked.
`boolean`	`isValueAxisAvail()` Indicates whehter chart has a value axis.
`void`	`setAutoScaling(boolean value)` True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.
`void`	`setCategoryAxisTitle(java.lang.String value)` Title of the category axis.
`void`	`setChartTitle(java.lang.String value)` Title of the chart.
`void`	`setChartType(ExcelChartType value)` Type of the chart.
`void`	`setDataRange(IXLSRange value)` DataRange for the chart series.
`void`	`setDepthPercent(int value)` Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
`void`	`setDestinationType(ExcelChartType value)` Gets chart type after type change.
`void`	`setDisplayAxisFieldButtons(boolean value)` Gets or sets a value indicating whether [show axis field buttons].
`void`	`setDisplayBlanksAs(ChartPlotEmptyType value)` Represents the way that blank cells are plotted on a chart.
`void`	`setDisplayEntireFieldButtons(boolean value)` Gets or sets a value indicating whether [show all field buttons].
`void`	`setDisplayLegendFieldButtons(boolean value)` Gets or sets a value indicating whether [show legend field buttons].
`void`	`setDisplayValueFieldButtons(boolean value)` Gets or sets a value indicating whether [show value field buttons].
`void`	`setElevation(int value)` Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).
`void`	`setGapDepth(int value)` Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )
`void`	`setHeight(double value)` Height of the chart in points (1/72 inch).
`void`	`setHeightPercent(int value)` Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
`void`	`setPerspective(int value)` Returns or sets the perspective for the 3-D chart view (0 to 100).
`void`	`setPivotChartType(ExcelChartType value)` Gets or sets the type of the pivot chart.
`void`	`setPivotTable(PivotTable value)` Gets or sets the pivot source.
`void`	`setPlotVisibleOnly(boolean value)` True if only visible cells are plotted.
`void`	`setRightAngleAxes(boolean value)` True if the chart axes are at right angles, independent of chart rotation or elevation.
`void`	`setRotation(int value)` Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees).
`void`	`setSecondaryCategoryAxisTitle(java.lang.String value)` Title of the secondary category axis.
`void`	`setSecondaryValueAxisTitle(java.lang.String value)` Title of the secondary value axis.
`void`	`setSeriesAxisTitle(java.lang.String value)` Title of the series axis.
`void`	`setSeriesDataFromRange(boolean value)` True if series are in rows in DataRange; False otherwise.
`void`	`setShowReportFilterFieldButtons(boolean value)` Gets or sets a value indicating whether [show report filter field buttons].
`void`	`setSizeWithWindow(boolean value)` True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
`void`	`setStyle(int value)` Style index for Excel 2007 chart.
`void`	`setToDefaultGridlines(ExcelChartType type)` Sets to default chart grid lines on chart type or serie type changing.
`void`	`setValueAxisTitle(java.lang.String value)` Title of the value axis.
`void`	`setWallsAndGridlines2D(boolean value)` True if gridlines are drawn two-dimensionally on a 3-D chart.
`void`	`setWidth(double value)` Width of the chart in points (1/72 inch).
`void`	`setXPos(double value)` X coordinate of the upper-left corner of the chart in points (1/72 inch).
`void`	`setYPos(double value)` Y coordinate of the upper-left corner of the chart in points (1/72 inch).
`void`	`setZoomToFit(boolean value)` Gets or sets zoomToFit value.

Methods inherited from class com.spire.xls.core.spreadsheet.XlsWorksheetBase
activate, getArcShapes, getCharts, getCheckBoxes, getCodeName, getComboBoxes, getComments, getDefaultGridlineColor, getFirstColumn, getFirstRow, getGridLineColor, getGroupBoxes, getHeaderFooterShapes, getIndex, getLastColumn, getLastRow, getLeftVisibleColumn, getName, getOvalShapes, getParentWorkbook, getPictures, getProtectContents, getProtectDrawingObjects, getProtection, getProtectScenarios, getPrstGeomShapes, getRadioButtons, getRealIndex, getRectangleShapes, getScrollBarShapes, getShapes, getSheetId, getSpinnerShapes, getTabColor, getTabColorObject, getTabKnownColor, getTextBoxes, getTopVisibleRow, getTypedCheckBoxes, getTypedComboBoxes, getTypedLines, getTypedPictures, getTypedTextBoxes, getUnknownVmlShapes, getVisibility, getVmlShapesCount, getWorkbook, getZoom, hasPictures, hasVmlShapes, isPasswordProtected, isRightToLeft, isRightToLeft, isSelected, protect, protect, select, selectTab, setChanged, setGridLineColor, setIndex, setLeftVisibleColumn, setName, setRealIndex, setTabColor, setTabKnownColor, setTopVisibleRow, setUnknownVmlShapes, setVisibility, setZoom, unprotect, unprotect, unselect, unselect

Methods inherited from class com.spire.xls.core.spreadsheet.XlsWorksheetBase

activate, getArcShapes, getCharts, getCheckBoxes, getCodeName, getComboBoxes, getComments, getDefaultGridlineColor, getFirstColumn, getFirstRow, getGridLineColor, getGroupBoxes, getHeaderFooterShapes, getIndex, getLastColumn, getLastRow, getLeftVisibleColumn, getName, getOvalShapes, getParentWorkbook, getPictures, getProtectContents, getProtectDrawingObjects, getProtection, getProtectScenarios, getPrstGeomShapes, getRadioButtons, getRealIndex, getRectangleShapes, getScrollBarShapes, getShapes, getSheetId, getSpinnerShapes, getTabColor, getTabColorObject, getTabKnownColor, getTextBoxes, getTopVisibleRow, getTypedCheckBoxes, getTypedComboBoxes, getTypedLines, getTypedPictures, getTypedTextBoxes, getUnknownVmlShapes, getVisibility, getVmlShapesCount, getWorkbook, getZoom, hasPictures, hasVmlShapes, isPasswordProtected, isRightToLeft, isRightToLeft, isSelected, protect, protect, select, selectTab, setChanged, setGridLineColor, setIndex, setLeftVisibleColumn, setName, setRealIndex, setTabColor, setTabKnownColor, setTopVisibleRow, setUnknownVmlShapes, setVisibility, setZoom, unprotect, unprotect, unselect, unselect

Methods inherited from class com.spire.xls.core.spreadsheet.XlsObject
`dispose`

Methods inherited from interface com.spire.xls.core.IChart
`getHeightForDouble, getName, getWidthForDouble`

Constructor Detail

XlsChart

public XlsChart(java.lang.Object parent)

Method Detail

getChartType

public ExcelChartType getChartType()

Type of the chart.

Specified by:: getChartType in interface IChart

setChartType

public void setChartType(ExcelChartType value)

Type of the chart.

Specified by:: setChartType in interface IChart

getDataRange

public IXLSRange getDataRange()

DataRange for the chart series.

Specified by:: getDataRange in interface IChart

setDataRange

public void setDataRange(IXLSRange value)

DataRange for the chart series.

Specified by:: setDataRange in interface IChart

getSeriesDataFromRange

public boolean getSeriesDataFromRange()

True if series are in rows in DataRange; False otherwise.

Specified by:: getSeriesDataFromRange in interface IChart

setSeriesDataFromRange

public void setSeriesDataFromRange(boolean value)

True if series are in rows in DataRange; False otherwise.

Specified by:: setSeriesDataFromRange in interface IChart

getPageSetup

public IChartPageSetup getPageSetup()

Page setup for the chart. Read-only.

Specified by:: getPageSetup in interface IChart

getXPos

public double getXPos()

X coordinate of the upper-left corner of the chart in points (1/72 inch).

Specified by:: getXPos in interface IChart

setXPos

public void setXPos(double value)

X coordinate of the upper-left corner of the chart in points (1/72 inch).

getYPos

public double getYPos()

Y coordinate of the upper-left corner of the chart in points (1/72 inch).

Specified by:: getYPos in interface IChart

setYPos

public void setYPos(double value)

Y coordinate of the upper-left corner of the chart in points (1/72 inch).

getWidth

public double getWidth()

Width of the chart in points (1/72 inch).

setWidth

public void setWidth(double value)

Width of the chart in points (1/72 inch).

getHeight

public double getHeight()

Height of the chart in points (1/72 inch).

setHeight

public void setHeight(double value)

Height of the chart in points (1/72 inch).

getPrimaryCategoryAxis

public IChartCategoryAxis getPrimaryCategoryAxis()

Primary category axis. Read-only.

Specified by:: getPrimaryCategoryAxis in interface IChart

getPrimaryValueAxis

public IChartValueAxis getPrimaryValueAxis()

Primary value axis. Read-only.

Specified by:: getPrimaryValueAxis in interface IChart

getPrimarySerieAxis

public IChartSeriesAxis getPrimarySerieAxis()

Primary serie axis. Read-only.

Specified by:: getPrimarySerieAxis in interface IChart

getSecondaryCategoryAxis

public IChartCategoryAxis getSecondaryCategoryAxis()

Secondary category axis. Read-only.

Specified by:: getSecondaryCategoryAxis in interface IChart

getSecondaryValueAxis

public IChartValueAxis getSecondaryValueAxis()

Secondary value axis. Read-only.

Specified by:: getSecondaryValueAxis in interface IChart

getChartArea

public IChartFrameFormat getChartArea()

Returns an object that represents the complete chart area for the chart. Read-only.

Specified by:: getChartArea in interface IChart

getPlotArea

public IChartFrameFormat getPlotArea()

Returns plot area frame format. Read-only.

Specified by:: getPlotArea in interface IChart

getWalls

public IChartWallOrFloor getWalls()

Represents chart walls. Read-only.

Specified by:: getWalls in interface IChart

getFloor

public IChartWallOrFloor getFloor()

Represents chart floor. Read-only.

Specified by:: getFloor in interface IChart

getDataTable

public IChartDataTable getDataTable()

Represents charts dataTable object.

Specified by:: getDataTable in interface IChart

hasDataTable

public boolean hasDataTable()

True if the chart has a data table.

Specified by:: hasDataTable in interface IChart

hasDataTable

public void hasDataTable(boolean value)

True if the chart has a data table.

Specified by:: hasDataTable in interface IChart

getLegend

public IChartLegend getLegend()

Represents chart legend.

Specified by:: getLegend in interface IChart

hasLegend

public boolean hasLegend()

True if the chart has a legend object.

Specified by:: hasLegend in interface IChart

hasLegend

public void hasLegend(boolean value)

True if the chart has a legend object.

Specified by:: hasLegend in interface IChart

getRotation

public int getRotation()

Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees).

Specified by:: getRotation in interface IChart

setRotation

public void setRotation(int value)

Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees).

Specified by:: setRotation in interface IChart

getElevation

public int getElevation()

Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).

Specified by:: getElevation in interface IChart

setElevation

public void setElevation(int value)

Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).

Specified by:: setElevation in interface IChart

getPerspective

public int getPerspective()

Returns or sets the perspective for the 3-D chart view (0 to 100).

Specified by:: getPerspective in interface IChart

setPerspective

public void setPerspective(int value)

Returns or sets the perspective for the 3-D chart view (0 to 100).

Specified by:: setPerspective in interface IChart

getHeightPercent

public int getHeightPercent()

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).

Specified by:: getHeightPercent in interface IChart

setHeightPercent

public void setHeightPercent(int value)

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).

Specified by:: setHeightPercent in interface IChart

getDepthPercent

public int getDepthPercent()

Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

Specified by:: getDepthPercent in interface IChart

setDepthPercent

public void setDepthPercent(int value)

Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

Specified by:: setDepthPercent in interface IChart

getDestinationType

public ExcelChartType getDestinationType()

Gets chart type after type change.

setDestinationType

public void setDestinationType(ExcelChartType value)

Gets chart type after type change.

getGapDepth

public int getGapDepth()

Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )

Specified by:: getGapDepth in interface IChart

setGapDepth

public void setGapDepth(int value)

Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )

Specified by:: setGapDepth in interface IChart

getRightAngleAxes

public boolean getRightAngleAxes()

True if the chart axes are at right angles, independent of chart rotation or elevation.

Specified by:: getRightAngleAxes in interface IChart

setRightAngleAxes

public void setRightAngleAxes(boolean value)

True if the chart axes are at right angles, independent of chart rotation or elevation.

Specified by:: setRightAngleAxes in interface IChart

getAutoScaling

public boolean getAutoScaling()

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.

Specified by:: getAutoScaling in interface IChart

setAutoScaling

public void setAutoScaling(boolean value)

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.

Specified by:: setAutoScaling in interface IChart

getWallsAndGridlines2D

public boolean getWallsAndGridlines2D()

True if gridlines are drawn two-dimensionally on a 3-D chart.

Specified by:: getWallsAndGridlines2D in interface IChart

setWallsAndGridlines2D

public void setWallsAndGridlines2D(boolean value)

True if gridlines are drawn two-dimensionally on a 3-D chart.

Specified by:: setWallsAndGridlines2D in interface IChart

hasPlotArea

public boolean hasPlotArea()

Indicates whether chart has plot area.

Specified by:: hasPlotArea in interface IChart

hasPlotArea

public void hasPlotArea(boolean value)

Indicates whether chart has plot area.

Specified by:: hasPlotArea in interface IChart

getDisplayBlanksAs

public ChartPlotEmptyType getDisplayBlanksAs()

Represents the way that blank cells are plotted on a chart.

Specified by:: getDisplayBlanksAs in interface IChart

setDisplayBlanksAs

public void setDisplayBlanksAs(ChartPlotEmptyType value)

Represents the way that blank cells are plotted on a chart.

Specified by:: setDisplayBlanksAs in interface IChart

getPlotVisibleOnly

public boolean getPlotVisibleOnly()

True if only visible cells are plotted. False if both visible and hidden cells are plotted.

Specified by:: getPlotVisibleOnly in interface IChart

setPlotVisibleOnly

public void setPlotVisibleOnly(boolean value)

True if only visible cells are plotted. False if both visible and hidden cells are plotted.

Specified by:: setPlotVisibleOnly in interface IChart

getSizeWithWindow

public boolean getSizeWithWindow()

True if Microsoft Excel resizes the chart to match the size of the chart sheet window. False if the chart size isn't attached to the window size. Applies only to chart sheets.

Specified by:: getSizeWithWindow in interface IChart

setSizeWithWindow

public void setSizeWithWindow(boolean value)

True if Microsoft Excel resizes the chart to match the size of the chart sheet window. False if the chart size isn't attached to the window size. Applies only to chart sheets.

Specified by:: setSizeWithWindow in interface IChart

getPivotTable

public PivotTable getPivotTable()

Gets or sets the pivot source.

Specified by:: getPivotTable in interface IChart

setPivotTable

public void setPivotTable(PivotTable value)

Gets or sets the pivot source.

Specified by:: setPivotTable in interface IChart

getPivotChartType

public ExcelChartType getPivotChartType()

Gets or sets the type of the pivot chart.

Specified by:: getPivotChartType in interface IChart

setPivotChartType

public void setPivotChartType(ExcelChartType value)

Gets or sets the type of the pivot chart.

Specified by:: setPivotChartType in interface IChart

getDisplayEntireFieldButtons

public boolean getDisplayEntireFieldButtons()

Gets or sets a value indicating whether [show all field buttons].

Specified by:: getDisplayEntireFieldButtons in interface IChart

setDisplayEntireFieldButtons

public void setDisplayEntireFieldButtons(boolean value)

Gets or sets a value indicating whether [show all field buttons].

Specified by:: setDisplayEntireFieldButtons in interface IChart

getDisplayValueFieldButtons

public boolean getDisplayValueFieldButtons()

Gets or sets a value indicating whether [show value field buttons].

Specified by:: getDisplayValueFieldButtons in interface IChart

setDisplayValueFieldButtons

public void setDisplayValueFieldButtons(boolean value)

Gets or sets a value indicating whether [show value field buttons].

Specified by:: setDisplayValueFieldButtons in interface IChart

getDisplayAxisFieldButtons

public boolean getDisplayAxisFieldButtons()

Gets or sets a value indicating whether [show axis field buttons].

Specified by:: getDisplayAxisFieldButtons in interface IChart

setDisplayAxisFieldButtons

public void setDisplayAxisFieldButtons(boolean value)

Gets or sets a value indicating whether [show axis field buttons].

Specified by:: setDisplayAxisFieldButtons in interface IChart

getDisplayLegendFieldButtons

public boolean getDisplayLegendFieldButtons()

Gets or sets a value indicating whether [show legend field buttons].

Specified by:: getDisplayLegendFieldButtons in interface IChart

setDisplayLegendFieldButtons

public void setDisplayLegendFieldButtons(boolean value)

Gets or sets a value indicating whether [show legend field buttons].

Specified by:: setDisplayLegendFieldButtons in interface IChart

getShowReportFilterFieldButtons

public boolean getShowReportFilterFieldButtons()

Gets or sets a value indicating whether [show report filter field buttons].

Specified by:: getShowReportFilterFieldButtons in interface IChart

setShowReportFilterFieldButtons

public void setShowReportFilterFieldButtons(boolean value)

Gets or sets a value indicating whether [show report filter field buttons].

Specified by:: setShowReportFilterFieldButtons in interface IChart

canChartBubbleLabel

public boolean canChartBubbleLabel()

Returns True if chart can have bubble data labels. Read-only.

canChartHaveSeriesLines

public boolean canChartHaveSeriesLines()

Returns True if chart can have series lines. Read-only.

canChartPercentageLabel

public boolean canChartPercentageLabel()

Returns True if chart can have percentage data labels. Read-only.

getCategoryAxisTitle

public java.lang.String getCategoryAxisTitle()

Title of the category axis.

setCategoryAxisTitle

public void setCategoryAxisTitle(java.lang.String value)

Title of the category axis.

getChartStartType

public java.lang.String getChartStartType()

Returns start type of chart type. Read-only.

getChartTitle

public java.lang.String getChartTitle()

Title of the chart.

setChartTitle

public void setChartTitle(java.lang.String value)

Title of the chart.

getChartTitleFont

public IFont getChartTitleFont()

Returns object that describes chart title area. Read-only.

getDefaultLinePattern

public ChartLinePatternType getDefaultLinePattern()

Returns default line pattern for the chart. Read-only.

getFont

public FontWrapper getFont()

Gets font which used for displaying axis text .

isCategoryAxisAvail

public boolean isCategoryAxisAvail()

Indicates whether chart has a category axis. Read-only.

isChart_100

public boolean isChart_100()

Returns True if chart is 100%. Read-only.

isChart3D

public boolean isChart3D()

Returns True if chart is 3D. Read-only.

isChartBar

public boolean isChartBar()

Returns True if chart is a bar chart. Read-only.

isChartBubble

public boolean isChartBubble()

Returns True if chart is a bubble chart. Read-only.

isChartCone

public boolean isChartCone()

Returns True if chart is a conical shape. Read-only.

isChartCylinder

public boolean isChartCylinder()

Returns True if chart is a cylinder shape. Read-only.

isChartDoughnut

public boolean isChartDoughnut()

Returns True if chart is a doughnut chart. Read-only.

isChartExploded

public boolean isChartExploded()

Returns True if chart is exploded. Read-only.

isChartFloor

public boolean isChartFloor()

Returns True if chart has floor. Read-only.

isChartLine

public boolean isChartLine()

Returns True if chart is line. Read-only.

isChartPie

public boolean isChartPie()

Returns True if chart is a pie chart. Read-only.

isChartPyramid

public boolean isChartPyramid()

Returns True if chart is a pyramid shape. Read-only.

isChartRadar

public boolean isChartRadar()

Returns True if chart is a radar chart. Read-only.

isChartScatter

public boolean isChartScatter()

Returns True if chart is a scatter chart. Read-only.

isChartSmoothedLine

public boolean isChartSmoothedLine()

Returns True if chart has smoothed lines. Read-only.

isChartStock

public boolean isChartStock()

Returns True if this is a stock chart. Read-only.

isChartVeryColor

public boolean isChartVeryColor()

Returns True if chart should have a different color for each series value. Read-only.

isChartVolume

public boolean isChartVolume()

Returns True if chart is a stock chart with volume. Read-only.

isChartWalls

public boolean isChartWalls()

Returns True if chart has walls. Read-only.

isClustered

public boolean isClustered()

Returns True if chart is a clustered chart. Read-only.

isEmbeded

public boolean isEmbeded()

Gets value indicating whether chart is embeded into worksheet.

isPerspective

public boolean isPerspective()

Returns True if chart has perspective. Read-only.

isPivot3DChart

public boolean isPivot3DChart()

Gets a value indicating whether this instance is pivot 3D chart .

isSecondaryAxes

public boolean isSecondaryAxes()

Returns True if at least one of the secondary axes is present. Read-only.

isSecondaryAxes

public void isSecondaryAxes(boolean value)

Returns True if at least one of the secondary axes is present. Read-only.

isSeriesLines

public boolean isSeriesLines()

Returns True if chart has series lines. Read-only.

isSpecialDataLabels

public boolean isSpecialDataLabels()

Returns True if chart needs special data labels serialization. Read-only.

isStacked

public boolean isStacked()

Returns True if chart is stacked. Read-only.

isValueAxisAvail

public boolean isValueAxisAvail()

Indicates whehter chart has a value axis. Read-only.

getNeedDataFormat

public boolean getNeedDataFormat()

Returns True if chart needs data format to be saved. Read-only.

getNeedDropBar

public boolean getNeedDropBar()

Returns True if chart needs drop bars to be saved. Read-only.

getNeedMarkerFormat

public boolean getNeedMarkerFormat()

Returns True if chart needs marker format to be saved. Read-only.

getNoPlotArea

public boolean getNoPlotArea()

Returns True if chart has no plot area. Read-only.

getStyle

public int getStyle()

Style index for Excel 2007 chart.

setStyle

public void setStyle(int value)

Style index for Excel 2007 chart.

getSupportWallsAndFloor

public boolean getSupportWallsAndFloor()

Indicates whether this chart supports walls and floor. Read-only.

getZoomToFit

public boolean getZoomToFit()

Gets or sets zoomToFit value.

setZoomToFit

public void setZoomToFit(boolean value)

Gets or sets zoomToFit value.

getSecondaryCategoryAxisTitle

public java.lang.String getSecondaryCategoryAxisTitle()

Title of the secondary category axis.

setSecondaryCategoryAxisTitle

public void setSecondaryCategoryAxisTitle(java.lang.String value)

Title of the secondary category axis.

getSecondaryValueAxisTitle

public java.lang.String getSecondaryValueAxisTitle()

Title of the secondary value axis.

setSecondaryValueAxisTitle

public void setSecondaryValueAxisTitle(java.lang.String value)

Title of the secondary value axis.

getSeriesAxisTitle

public java.lang.String getSeriesAxisTitle()

Title of the series axis.

setSeriesAxisTitle

public void setSeriesAxisTitle(java.lang.String value)

Title of the series axis.

getValueAxisTitle

public java.lang.String getValueAxisTitle()

Title of the value axis.

setValueAxisTitle

public void setValueAxisTitle(java.lang.String value)

Title of the value axis.

hasChartArea

public boolean hasChartArea()

Indicates whether chart has chart area.

hasChartArea

public void hasChartArea(boolean value)

Indicates whether chart has chart area.

hasChartTitle

public boolean hasChartTitle()

Indicates wheather the chart has title

hasFloor

public boolean hasFloor()

Gets value indicating whether floor object was created.

hasWalls

public boolean hasWalls()

Gets value indicating whether floor object was created.

hasPivotTable

public boolean hasPivotTable()

Indicates whether contains pivot table.

checkForSupportGridLine

public boolean checkForSupportGridLine()

Chacks for existing gridlines in chart.

Returns:: Returns true if can exist; otherwise false.

deepClone

public XlsChart deepClone(java.util.HashMap hashNewNames,
                          java.lang.Object parent,
                          java.util.HashMap dicFontIndexes)

Clones current instance.

Parameters:: hashNewNames - Hash table with new Worksheet names.; parent - Parent object.; dicFontIndexes - Dictionary with new font indexes.
Returns:: Returns clone of current object.

deepClone

public java.lang.Object deepClone(java.lang.Object parent)

Clones current instance.

Overrides:: deepClone in class XlsWorksheetBase

Parameters:: parent - Parent object.
Returns:: Returns clone of current object.

setToDefaultGridlines

public void setToDefaultGridlines(ExcelChartType type)

Sets to default chart grid lines on chart type or serie type changing.

Parameters:: type - Represents type to change.

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.spire.xls.core.spreadsheet.charts Class XlsChart

XlsChart

getChartType

setChartType

getDataRange

setDataRange

getSeriesDataFromRange

setSeriesDataFromRange

getPageSetup

getXPos

setXPos

getYPos

setYPos

getWidth

setWidth

getHeight

setHeight

getPrimaryCategoryAxis

getPrimaryValueAxis

getPrimarySerieAxis

getSecondaryCategoryAxis

getSecondaryValueAxis

getChartArea

getPlotArea

getWalls

getFloor

getDataTable

hasDataTable

hasDataTable

getLegend

hasLegend

hasLegend

getRotation

setRotation

getElevation

setElevation

getPerspective

setPerspective

getHeightPercent

setHeightPercent

getDepthPercent

setDepthPercent

getDestinationType

setDestinationType

getGapDepth

setGapDepth

getRightAngleAxes

setRightAngleAxes

getAutoScaling

setAutoScaling

getWallsAndGridlines2D

setWallsAndGridlines2D

hasPlotArea

hasPlotArea

getDisplayBlanksAs

setDisplayBlanksAs

getPlotVisibleOnly

setPlotVisibleOnly

getSizeWithWindow

setSizeWithWindow

getPivotTable

setPivotTable

getPivotChartType

setPivotChartType

getDisplayEntireFieldButtons

setDisplayEntireFieldButtons

getDisplayValueFieldButtons

setDisplayValueFieldButtons

getDisplayAxisFieldButtons

setDisplayAxisFieldButtons

getDisplayLegendFieldButtons

setDisplayLegendFieldButtons

getShowReportFilterFieldButtons

setShowReportFilterFieldButtons

canChartBubbleLabel

canChartHaveSeriesLines

canChartPercentageLabel

getCategoryAxisTitle

setCategoryAxisTitle

getChartStartType

com.spire.xls.core.spreadsheet.charts
Class XlsChart