SeriesInSubchart |
Returns the number of series on each subchart. Note that this property only works in xlsx files: In xls files it will always return 0.
|
AddSubchart |
Adds a new subchart to the existing chart. Note that if the current active subchart is empty, this method will not add a new subchart, but replace the empty one. In that case, SubchartCount won't change.
This method only works in xlsx files, not xls.
|
SetChartOptions |
Sets the chart options of a specific subchart inside the chart. Note that while a chart can have multiple subcharts inside (for example one pie subchart and one line subchart), normally there is only one subchart and so the SubchartPos parameter is normally 1.
|
GetSeries |
Returns a series definition.
|
GetSeriesInSubchart |
Returns a series definition for a given subchart. Note: This method only works in xlsx files.
|
SetSeries |
Sets a Series value. Note that for xlsx charts, this will change the **data range** and the **options** of the series. If you only want to change the data range, pass null options to the method.
|
SetSeriesInSubchart |
Sets a Series value. Note that for xlsx charts, this will change the **data range** and the **options** of the series. If you only want to change the data range, pass null options to the method.
|
AddSeries |
Adds a series to the chart.
|
DeleteSeries |
Deletes the series at position index.
|
GetBubbleSeries |
Returns the bubble definition for a series when in a bubble chart.
|
SetBubbleSeries |
Sets a Series value. Note that for xlsx charts, this will change the **data range** and the **options** of the series. If you only want to change the data range, pass null options to the method.
|
GetChartAxis |
Returns the axis information for this chart. Note that this might be more than one, if the chart has a secondary axis.
|
SetChartAxis |
Sets the options for either the primary or secondary pair of axis.
|
GetChartLegend |
Information about the Legend of the chart.
|
SetChartLegend |
Sets the legend properties.
|
RemoveChartLegend |
Removes the Legend from the chart.
|
GetTitle |
Returns the title of the chart.
|
SetTitle |
Sets the title of the chart. This method is only implemented for xlsx charts.
|
GetDataLabels |
Returns all the labels for the chart. Note that Axis have their labels defined inside their own definition.
|
SetDataLabels |
Changes the labels for the chart. You should always get the values with GetDataLabels, modify them, and change them back with this method.
|
GetDataLabelsRange |
Returns the range of cells for a "Label Contains: " "Value from Cells" option in the labels. Note that for this to work, you also need to use the string [CELLRANGE] in the label definition.
|
SetDataLabelsRange |
Sets the range of cells for a "Label Contains: " "Value from Cells" option in the labels. Note that for this to work, you also need to use the string [CELLRANGE] in the label definition.
|
GetTrendline |
Gets a trendline for a chart. This method is only implemented for xlsx charts.
|
SetTrendline |
Gets a trendline for a chart. This method is only implemented for xlsx charts.
|
GetImageProperties |
Returns image position and size.
|
AddImage |
Overloaded AddImage(TUIImage, IImageProperties) AddImage(TBytes, IImageProperties) AddImage(TStream, IImageProperties) AddImage(string, IImageProperties) AddImage(TBytes, TXlsImgType, IImageProperties) AddImage(TStream, TXlsImgType, IImageProperties)
|
DeleteImage |
Deletes the image at position imageIndex. Note that if the image is grouped, this will remove the full group. To remove a particular image inside a group, use IEmbeddedObjects.DeleteObject(Integer, string).
|
ClearImage |
Overloaded ClearImage(Integer) ClearImage(Integer, Boolean, string)
|
AddAutoShape |
Adds an autoshape to an existing embedded chart. Note that the coordinates for the shape are in chart coords, meaning that only row1, row2, col1 and col2 are used, and they represent the percentage in 1/4000 of the coordinate. So 0 means the top and left of the parent chart, and 4000 means the bottom and right of the parent chart.
|