Search
Chart Members
Methods
 


Represents a chart in a drawing within a worksheet.

The following tables list the members exposed by the Chart type.

 Public Methods

  Name Description

bringForward

Moves this object one step up in the z-order. (Inherited from InteractiveObject.)

bringToFront

Brings this object to the top of the z-order. (Inherited from InteractiveObject.)

dispose

Disposes this object of any unmanaged resources it might hold.

draw

 

getAnchor

Gets the anchor of this object. (Inherited from InteractiveObject.)

getAnchorPosition

Gets the anchor position of this object. (Inherited from InteractiveObject.)

getAxisColor

Gets the color of the chart axes.

getAxisSize

Gets the thickness of the chart axes, or null, to use a hairline thickness.

getAxisStyle

Gets the style of the chart axes, or null, to draw solid lines.

getDefaultColors

Gets the default colors for data series that do not have explicitly defined colors.

getDefaultLineSize

Gets the default thickness in line and radar charts for series that have no explicitly specified line size.

getDefaultSeriesNameFormat

Gets the format of the names of the data series that do not have an explicitly defined name.

getDescription

Gets the object description. (Inherited from InteractiveObject.)

getFill

Gets a brush used to fill the background of the chart.

getFontBold

Gets a value indicating whether the text in the chart is bold.

getFontItalic

Gets a value indicating whether the text in the chart is italic.

getFontName

Gets the font of the texts in the chart.

getFontSize

Gets the font size of the texts of the chart.

getFontStrikeout

Gets a value indicating whether the text in the chart is with a line through the middle.

getFontUnderline

Gets a value indicating whether the text in the chart is underlined.

getFromColumn

Gets the zero-based index of the column of the cell to which the object is anchored. (Inherited from InteractiveObject.)

getFromRow

Gets the zero-based index of the row of the cell to which the object is anchored. (Inherited from InteractiveObject.)

getGridLineColor

Gets the color of the major grid lines.

getGridLineSize

Gets the thickness of the major grid lines, or a, to use a hairline thickness.

getGridLineStyle

Gets the style of the major grid lines, or null, to draw solid lines.

getHeight

Gets the desired height, or null, to calculate the height automatically. (Inherited from InteractiveObject.)

getHorizontalOffset

Gets the horizontal offset of the object from its anchor. (Inherited from InteractiveObject.)

getLegendBorderColor

Gets the border color of the legend, or null, to hide the border.

getLegendBorderSize

Gets the border thickness of the legend, or null, to use a hairline thickness.

getLegendBorderStyle

Gets the border style of the legend, or null, to use a solid line.

getLegendFill

Gets a brush used to fill the legend's background.

getLegendFontBold

Gets a value indicating whether the legend text is bold, or null, to use the FontBold property.

getLegendFontItalic

Gets a value indicating whether the legend text is italic, or null, to use the FontItalic property.

getLegendFontName

Gets the font name of the legend, or null, to use the FontName property.

getLegendFontSize

Gets the font size of the legend, or null, to use the FontSize property.

getLegendFontStrikeout

Gets a value indicating whether the legend text is with a line through the middle, or null, to use the FontStrikeout property.

getLegendFontUnderline

Gets a value indicating whether the legend text is underlined, or null, to use the FontUnderline property.

getLegendLanes

Gets the number of columns or rows to use when layouting items inside the legend, or null, to use the default number of columns or rows, which is 1.

getLegendPosition

Gets the legend position.

getLegendTextColor

Gets the color of the texts in the legend, or null, to use the TextColor property.

getLineColor

Gets the outline color of this object. (Inherited from InteractiveObject.)

getLineSize

Gets the thickness of the object's outline. (Inherited from InteractiveObject.)

getLineStyle

Gets the style of the object's outline. (Inherited from InteractiveObject.)

getLocked

Gets a value indicating whether this object can be interacted with. (Inherited from InteractiveObject.)

getMarkShape

Gets the shape of marks in the chart, or null, to use alternating shapes.

getPlotBorderColor

Gets the border color of the chart's plot area, or null, to hide the border.

getPlotBorderSize

Gets the border thickness of the chart's plot area, or null, to use a hairline thickness.

getPlotBorderStyle

Gets the border style of the chart's plot area, or null, to use a solid line.

getPlotFill

Gets a brush used to fill the background of the chart's plot area.

getSeries

Gets a collection with the data series of the chart.

getShowLegend

Gets a value indicating whether to display the chart's legend.

getTextColor

Gets the color of the texts in the chart.

getTitle

Gets the object title. (Inherited from InteractiveObject.)

getTitleFontBold

Gets a value indicating whether the chart title is bold, or null, to use the FontBold property.

getTitleFontItalic

Gets a value indicating whether the chart title is italic, or null, to use the FontItalic property.

getTitleFontName

Gets the font of the chart title, or null, to use the FontName property.

getTitleFontSize

Gets the font size of the chart title, or null, to use the FontSize property.

getTitleFontStrikeout

Gets a value indicating whether the chart title is with a line through the middle, or null, to use the FontStrikeout property.

getTitleFontUnderline

Gets a value indicating whether the chart title is underlined, or null, to use the FontUnderline property.

getTitleTextColor

Gets the color of the chart title, or null, to use the TextColor property.

getType

Gets the type of the chart.

getVerticalOffset

Gets the vertical offset of the object from its origin. (Inherited from InteractiveObject.)

getWidth

Gets the desired width, or null, to calculate width automatically. (Inherited from InteractiveObject.)

getXAxisSettings

Gets the settings for the category label axis of the chart, if the chart is an axes chart.

getYAxisSettings

Gets the settings for the value axis of the chart, if the chart is an axes chart.

isLockedToCell

Gets a value indicating whether this object is always locked to a cell in the worksheet. (Inherited from InteractiveObject.)

sendBackward

Moves this object one step down in the z-order. (Inherited from InteractiveObject.)

sendToBack

Sends this object to the bottom of the z-order. (Inherited from InteractiveObject.)

setAnchor

Sets the anchor of this object. (Inherited from InteractiveObject.)

setAnchorPosition

Sets the anchor position of this object. (Inherited from InteractiveObject.)

setAxisColor

 

setAxisSize

Sets the thickness of the chart axes, or null, to use a hairline thickness.

setAxisStyle

Sets the style of the chart axes, or null, to draw solid lines.

setDataSource

Sets the chart data source to the specified range of cells.

setDefaultColors

Sets the default colors for data series that do not have explicitly defined colors.

setDefaultLineSize

Sets the default thickness in line and radar charts for series that have no explicitly specified line size.

setDefaultSeriesNameFormat

Sets the format of the names of the data series that do not have an explicitly defined name.

setDescription

Sets the object description. (Inherited from InteractiveObject.)

setFill

Sets a brush used to fill the background of the chart.

setFontBold

Sets a value indicating whether the text in the chart is bold.

setFontItalic

Sets a value indicating whether the text in the chart is italic.

setFontName

Sets the font of the texts in the chart.

setFontSize

Sets the font size of the texts of the chart.

setFontStrikeout

Sets a value indicating whether the text in the chart is with a line through the middle.

setFontUnderline

Sets a value indicating whether the text in the chart is underlined.

setFromColumn

Sets the zero-based index of the column of the cell to which the object is anchored. (Inherited from InteractiveObject.)

setFromRow

Sets the zero-based index of the row of the cell to which the object is anchored. (Inherited from InteractiveObject.)

setGridLineColor

Sets the color of the major grid lines.

setGridLineSize

Sets the thickness of the major grid lines, or null, to use a hairline thickness.

setGridLineStyle

Sets the style of the major grid lines, or null, to draw solid lines.

setHeight

Sets the desired height, or null, to calculate the height automatically. (Inherited from InteractiveObject.)

setHorizontalOffset

Sets the horizontal offset of the object from its anchor. (Inherited from InteractiveObject.)

setLegendBorderColor

Sets the border color of the legend, or null, to hide the border.

setLegendBorderSize

Sets the border thickness of the legend, or null, to use a hairline thickness.

setLegendBorderStyle

 

setLegendFill

Sets a brush used to fill the legend's background.

setLegendFontBold

Sets a value indicating whether the legend text is bold, or null, to use the FontBold property.

setLegendFontItalic

Sets a value indicating whether the legend text is italic, or null, to use the FontItalic property.

setLegendFontName

Sets the font name of the legend, or null, to use the FontName property.

setLegendFontSize

Sets the font size of the legend, or null, to use the FontSize property.

setLegendFontStrikeout

Sets a value indicating whether the legend text is with a line through the middle, or null, to use the FontStrikeout property.

setLegendFontUnderline

Sets a value indicating whether the legend text is underlined, or null, to use the FontUnderline property.

setLegendLanes

Sets the number of columns or rows to use when layouting items inside the legend, or null, to use the default number of columns or rows, which is 1.

setLegendPosition

Sets the legend position.

setLegendTextColor

Sets the color of the texts in the legend, or null, to use the TextColor property.

setLineColor

Sets the outline color of this object. (Inherited from InteractiveObject.)

setLineSize

Sets the thickness of the object's outline. (Inherited from InteractiveObject.)

setLineStyle

Sets the style of the object's outline. (Inherited from InteractiveObject.)

setLocked

Sets a value indicating whether this object can be interacted with. (Inherited from InteractiveObject.)

setMarkShape

Gets the shape of marks in the chart, or null, to use alternating shapes.

setPlotBorderColor

Sets the border color of the chart's plot area, or null, to hide the border.

setPlotBorderSize

Sets the border thickness of the chart's plot area, or null, to use a hairline thickness.

setPlotBorderStyle

Sets the border style of the chart's plot area, or null, to use a solid line.

setPlotFill

Sets a brush used to fill the background of the chart's plot area.

setShowLegend

Sets a value indicating whether to display the chart's legend.

setTextColor

Sets the color of the texts in the chart.

setTitle

Sets the object title. (Inherited from InteractiveObject.)

setTitleFontBold

Sets a value indicating whether the chart title is bold, or null, to use the FontBold property.

setTitleFontItalic

Sets a value indicating whether the chart title is italic, or null, to use the FontItalic property.

setTitleFontName

Sets the font of the chart title, or null, to use the FontName property.

setTitleFontSize

Sets the font size of the chart title, or null, to use the FontSize property.

setTitleFontStrikeout

Sets a value indicating whether the chart title is with a line through the middle, or null, to use the FontStrikeout property.

setTitleFontUnderline

Sets a value indicating whether the chart title is underlined, or null, to use the FontUnderline property.

setTitleTextColor

Sets the color of the chart title, or null, to use the TextColor property.

setType

Sets the type of the chart.

setVerticalOffset

Sets the vertical offset of the object from its origin. (Inherited from InteractiveObject.)

setWidth

Sets the desired width, or null, to calculate width automatically. (Inherited from InteractiveObject.)

 Protected Methods

  Name Description

getExtendsOutsideBounds

Gets a value indicating whether this object's visual can extend beyond the object's bounding rectangle. (Inherited from InteractiveObject.)

getRegardsMergedCells

Gets a value indicating whether this object is positioned relatively to the bounding rectangle of the merged cell if the object's cell is a part of a merged cell. (Inherited from InteractiveObject.)

onResized

This method is called when the object's size is changed.

 See Also