Chart

Chart class

Encapsulates the object that represents a single Excel chart.

class Chart;

Example

const { Workbook, ChartType } = AsposeCells;

var workbook = new Workbook();
var sheet = workbook.worksheets.get(0);
var cells = sheet.cells;
cells.get(0, 1).putValue("Income");
cells.get(1, 0).putValue("Company A");
cells.get(2, 0).putValue("Company B");
cells.get(3, 0).putValue("Company C");
cells.get(1, 1).putValue(10000);
cells.get(2, 1).putValue(20000);
cells.get(3, 1).putValue(30000);
var chartIndex = sheet.charts.add(ChartType.Column, 9, 9, 21, 15);
var chart = sheet.charts.get(chartIndex);
chart.nSeries.add("B2:B4", true);
chart.nSeries.categoryData = "A2:A4";
var aSeries = chart.nSeries.get(0);
aSeries.name = "=B1";
chart.showLegend = true;
chart.title.text = "Income Analysis";

Properties

Property	Type	Description
style	number	Gets and sets the builtin style.
chartObject	ChartShape	Readonly. Represents the chartShape;
hidePivotFieldButtons	boolean	Indicates whether hide the pivot chart field buttons only when the chart is PivotChart.
pivotOptions	PivotOptions	Readonly. Specifies the pivot controls that appear on the chart
pivotSource	string	The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.
plotBy	PlotDataByType	Readonly. Gets and sets whether plot by row or column.
plotEmptyCellsType	PlotEmptyCellsType	Gets and sets how to plot the empty cells.
plotVisibleCellsOnly	boolean	Indicates whether plot visible cells only.
displayNaAsBlank	boolean	Indicates whether displaying #N/A as blank value.
name	string	Gets and sets the name of the chart.
sizeWithWindow	boolean	True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
worksheet	Worksheet	Readonly. Gets the worksheet which contains this chart.
shapes	ShapeCollection	Readonly. Returns all drawing shapes in this chart.
printSize	PrintSizeType	Gets and sets the printed chart size.
type	ChartType	Gets or sets a chart’s type.
nSeries	SeriesCollection	Readonly. Gets a SeriesCollection collection representing the data series in the chart.
filteredNSeries	SeriesCollection	Readonly. Gets a SeriesCollection collection representing the data series that are filtered in the chart.
title	Title	Readonly. Gets the chart’s title.
subTitle	Title	Readonly. Gets the chart’s sub-title. Only for ODS format file.
plotArea	PlotArea	Readonly. Gets the chart’s plot area which includes axis tick labels.
chartArea	ChartArea	Readonly. Gets the chart area in the worksheet.
categoryAxis	Axis	Readonly. Gets the chart’s X axis.
valueAxis	Axis	Readonly. Gets the chart’s Y axis.
secondValueAxis	Axis	Readonly. Gets the chart’s second Y axis.
secondCategoryAxis	Axis	Readonly. Gets the chart’s second X axis.
seriesAxis	Axis	Readonly. Gets the chart’s series axis.
legend	Legend	Readonly. Gets the chart legend.
chartDataTable	ChartDataTable	Readonly. Represents the chart data table.
showLegend	boolean	Gets or sets a value indicating whether the chart legend will be displayed. Default is true.
isRectangularCornered	boolean	Gets or sets a value indicating whether the chart area is rectangular cornered. Default is true.
showDataTable	boolean	Gets or sets a value indicating whether the chart displays a data table.
firstSliceAngle	number	Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.
gapWidth	number	Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.
gapDepth	number	Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500.
floor	Floor	Readonly. Returns a Floor object that represents the walls of a 3-D chart.
walls	Walls	Readonly. Returns a Walls object that represents the walls of a 3-D chart.
backWall	Walls	Readonly. Returns a Walls object that represents the back wall of a 3-D chart.
sideWall	Walls	Readonly. Returns a Walls object that represents the side wall of a 3-D chart.
wallsAndGridlines2D	boolean	True if gridlines are drawn two-dimensionally on a 3-D chart.
rotationAngle	number	Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
elevation	number	Represents the elevation of the 3-D chart view, in degrees.
rightAngleAxes	boolean	True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts).
autoScaling	boolean	True if Microsoft Excel scales a 3-D chart so that it’s closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.
heightPercent	number	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
perspective	number	Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.
is3D	boolean	Readonly. Indicates whether the chart is a 3d chart.
depthPercent	number	Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
placement	PlacementType	Represents the way the chart is attached to the cells below it.
pageSetup	PageSetup	Readonly. Represents the page setup description in this chart.
line	Line	Readonly. Gets the line.

Methods

Method	Description
isCellReferedByChart(number, number, number)	Returns whether the cell refered by the chart.
isChartDataChanged()	Detects if a chart’s data source has changed.
refreshPivotData()	Refreshes chart’s data from pivot table.
changeTemplate(Uint8Array)	Change chart type with preset template.
move(number, number, number, number)	Moves the chart to a specified location.
calculate()	Calculates the custom position of plot area, axes if the position of them are auto assigned.
calculate(ChartCalculateOptions)	Calculates the custom position of plot area, axes if the position of them are auto assigned, with Chart Calculate Options.
toImageAsync(string)	Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
toImageAsync(string, ImageType)	Creates the chart image and saves it to a file in the specified image type.
toImageAsync(string, number)	Creates the chart image and saves it to a file in the Jpeg format.
toImageAsync(number)	Creates the chart image and saves it to a stream in the Jpeg format.
toImageAsync(ImageType)	Creates the chart image and saves it to a stream in the specified format.
toImageAsync(string, ImageOrPrintOptions)	Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
toImageAsync(ImageOrPrintOptions)	Creates the chart image and saves it to a stream in the specified format.
toImage(string)	Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
toImage(string, ImageType)	Creates the chart image and saves it to a file in the specified image type.
toImage(string, number)	Creates the chart image and saves it to a file in the Jpeg format.
toImage(number)	Creates the chart image and saves it to a stream in the Jpeg format.
toImage(ImageType)	Creates the chart image and saves it to a stream in the specified format.
toImage(string, ImageOrPrintOptions)	Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
toImage(ImageOrPrintOptions)	Creates the chart image and saves it to a stream in the specified format.
toPdfAsync(string)	Saves the chart to a pdf file.
toPdfAsync(string, number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)	Saves the chart to a pdf file.
toPdfAsync()	Creates the chart pdf and saves it to a stream.
toPdfAsync(number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)	Creates the chart pdf and saves it to a stream.
toPdf(string)	Saves the chart to a pdf file.
toPdf(string, number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)	Saves the chart to a pdf file.
toPdf()	Creates the chart pdf and saves it to a stream.
toPdf(number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)	Creates the chart pdf and saves it to a stream.
getActualSize()	Gets actual size of chart in unit of pixels.
hasAxis(AxisType, boolean)	Returns which axes exist on the chart.
switchRowColumn()	Switches row/column.
getChartDataRange()	Gets the data source range of the chart.
setChartDataRange(string, boolean)	Specifies data range for a chart.

style

Gets and sets the builtin style.

style : number;

Remarks

It should be between 1 and 48. Return -1 if it’s not be set.

chartObject

Readonly. Represents the chartShape;

chartObject : ChartShape;

hidePivotFieldButtons

Indicates whether hide the pivot chart field buttons only when the chart is PivotChart.

hidePivotFieldButtons : boolean;

pivotOptions

Readonly. Specifies the pivot controls that appear on the chart

pivotOptions : PivotOptions;

pivotSource

The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.

pivotSource : string;

Remarks

If the pivot table “PivotTable1” in the Worksheet “Sheet1” in the file “Book1.xls”. The pivotSource could be “[Book1.xls]Sheet1!PivotTable1” if the chart and the PivotTable is not in the same workbook. If you set this property ,the previous data source setting will be lost.

plotBy

Readonly. Gets and sets whether plot by row or column.

plotBy : PlotDataByType;

plotEmptyCellsType

Gets and sets how to plot the empty cells.

plotEmptyCellsType : PlotEmptyCellsType;

plotVisibleCellsOnly

Indicates whether plot visible cells only.

plotVisibleCellsOnly : boolean;

displayNaAsBlank

Indicates whether displaying #N/A as blank value.

displayNaAsBlank : boolean;

name

Gets and sets the name of the chart.

name : string;

sizeWithWindow

True if Microsoft Excel resizes the chart to match the size of the chart sheet window.

sizeWithWindow : boolean;

worksheet

Readonly. Gets the worksheet which contains this chart.

worksheet : Worksheet;

shapes

Readonly. Returns all drawing shapes in this chart.

shapes : ShapeCollection;

printSize

Gets and sets the printed chart size.

printSize : PrintSizeType;

type

Gets or sets a chart’s type.

type : ChartType;

nSeries

Readonly. Gets a SeriesCollection collection representing the data series in the chart.

nSeries : SeriesCollection;

filteredNSeries

Readonly. Gets a SeriesCollection collection representing the data series that are filtered in the chart.

filteredNSeries : SeriesCollection;

title

Readonly. Gets the chart’s title.

title : Title;

subTitle

Readonly. Gets the chart’s sub-title. Only for ODS format file.

subTitle : Title;

plotArea

Readonly. Gets the chart’s plot area which includes axis tick labels.

plotArea : PlotArea;

chartArea

Readonly. Gets the chart area in the worksheet.

chartArea : ChartArea;

categoryAxis

Readonly. Gets the chart’s X axis.

categoryAxis : Axis;

valueAxis

Readonly. Gets the chart’s Y axis.

valueAxis : Axis;

secondValueAxis

Readonly. Gets the chart’s second Y axis.

secondValueAxis : Axis;

secondCategoryAxis

Readonly. Gets the chart’s second X axis.

secondCategoryAxis : Axis;

seriesAxis

Readonly. Gets the chart’s series axis.

seriesAxis : Axis;

legend

Readonly. Gets the chart legend.

legend : Legend;

chartDataTable

Readonly. Represents the chart data table.

chartDataTable : ChartDataTable;

showLegend

Gets or sets a value indicating whether the chart legend will be displayed. Default is true.

showLegend : boolean;

isRectangularCornered

Gets or sets a value indicating whether the chart area is rectangular cornered. Default is true.

isRectangularCornered : boolean;

showDataTable

Gets or sets a value indicating whether the chart displays a data table.

showDataTable : boolean;

firstSliceAngle

Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.

firstSliceAngle : number;

gapWidth

Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.

gapWidth : number;

gapDepth

Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500.

gapDepth : number;

floor

Readonly. Returns a Floor object that represents the walls of a 3-D chart.

floor : Floor;

Remarks

This property doesn’t apply to 3-D pie charts.

walls

Readonly. Returns a Walls object that represents the walls of a 3-D chart.

walls : Walls;

Remarks

This property doesn’t apply to 3-D pie charts.

backWall

Readonly. Returns a Walls object that represents the back wall of a 3-D chart.

backWall : Walls;

sideWall

Readonly. Returns a Walls object that represents the side wall of a 3-D chart.

sideWall : Walls;

wallsAndGridlines2D

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

wallsAndGridlines2D : boolean;

rotationAngle

Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

rotationAngle : number;

Remarks

The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.

elevation

Represents the elevation of the 3-D chart view, in degrees.

elevation : number;

Remarks

The chart elevation is the height at which you view the chart, in degrees. The default is 15 for most chart types. The value of this property must be between -90 and 90, except for 3-D bar charts, where it must be between 0 and 44.

rightAngleAxes

True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts).

rightAngleAxes : boolean;

Remarks

If this property is True, the Perspective property is ignored.

autoScaling

True if Microsoft Excel scales a 3-D chart so that it’s closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.

autoScaling : boolean;

heightPercent

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

heightPercent : number;

perspective

Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.

perspective : number;

is3D

Readonly. Indicates whether the chart is a 3d chart.

is3D : boolean;

depthPercent

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

depthPercent : number;

placement

Represents the way the chart is attached to the cells below it.

placement : PlacementType;

pageSetup

Readonly. Represents the page setup description in this chart.

pageSetup : PageSetup;

line

Readonly. Gets the line.

line : Line;

isCellReferedByChart(number, number, number)

Returns whether the cell refered by the chart.

isCellReferedByChart(sheetIndex: number, rowIndex: number, columnIndex: number) : boolean;

Parameters:

Parameter	Type	Description
sheetIndex	number	The sheet Index.-1 means the worksheet which contains current chart.
rowIndex	number	The row index
columnIndex	number	The column index

isChartDataChanged()

Detects if a chart’s data source has changed.

isChartDataChanged() : boolean;

Returns

Returns true if the chart has changed otherwise returns false

Remarks

The method detects the changes in the chart’s data source before rendering the chart to image format. At first Chart.toImage call, the chart source data (e.g. XValuesParseData, ValuesParseData) will be recorded. Before calling the Chart.toImage method again, call IsChartDataChanged method to check if Chart needs re-rendering.

refreshPivotData()

Refreshes chart’s data from pivot table.

refreshPivotData() : void;

Remarks

We will gather data from pivot data source to the pivot table report. This method is only used to gather all data to a pivot chart.

changeTemplate(Uint8Array)

Change chart type with preset template.

changeTemplate(data: Uint8Array) : void;

Parameters:

Parameter	Type	Description
data	number[]	The data of chart template file(.crtx).

move(number, number, number, number)

Moves the chart to a specified location.

move(upperLeftRow: number, upperLeftColumn: number, lowerRightRow: number, lowerRightColumn: number) : void;

Parameters:

Parameter	Type	Description
upperLeftRow	number	Upper left row index.
upperLeftColumn	number	Upper left column index.
lowerRightRow	number	Lower right row index
lowerRightColumn	number	Lower right column index

calculate()

Calculates the custom position of plot area, axes if the position of them are auto assigned.

calculate() : void;

calculate(ChartCalculateOptions)

Calculates the custom position of plot area, axes if the position of them are auto assigned, with Chart Calculate Options.

calculate(calculateOptions: ChartCalculateOptions) : void;

Parameters:

Parameter	Type	Description
calculateOptions	ChartCalculateOptions

toImageAsync(string)

Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.

toImageAsync(imageFile: string) : Promise<void>;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.

Returns

Promise

Remarks

The format of the image is specified by using the extension of the file name. For example, if you specify “myfile.png”, then the image will be saved in the PNG format. The following file extensions are recognized: .bmp, .gif, .png, .jpg, .jpeg, .tiff, .tif, .emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImageAsync(string, ImageType)

Creates the chart image and saves it to a file in the specified image type.

toImageAsync(imageFile: string, imageType: ImageType) : Promise<void>;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.
imageType	ImageType	The image type in which to save the image.

Returns

Promise

Remarks

The type of the image is specified by using imageType. The following types are supported: ImageType.Bmp, ImageType.Gif, ImageType.Png, ImageType.Jpeg, ImageType.Tiff, ImageType.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImageAsync(string, number)

Creates the chart image and saves it to a file in the Jpeg format.

toImageAsync(imageFile: string, jpegQuality: number) : Promise<void>;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.
jpegQuality	number	Jpeg quality.

Returns

Promise

Remarks

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. NOTE: This method is now obsolete. Instead, please use ToImage(string,ImageOrPrintOptions) method with specified quality. This method will be removed 12 months later since March 2025. Aspose apologizes for any inconvenience you may have experienced.

toImageAsync(number)

Creates the chart image and saves it to a stream in the Jpeg format.

toImageAsync(jpegQuality: number) : Promise<Uint8Array>;

Parameters:

Parameter	Type	Description
jpegQuality	number	Jpeg quality.

Returns

The result stream

Remarks

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImageAsync(ImageType)

Creates the chart image and saves it to a stream in the specified format.

toImageAsync(imageType: ImageType) : Promise<Uint8Array>;

Parameters:

Parameter	Type	Description
imageType	ImageType	The image type in which to save the image.

Returns

The result stream

Remarks

The type of the image is specified by using imageType. The following types are supported: ImageType.Bmp, ImageType.Gif, ImageType.Png, ImageType.Jpeg, ImageType.Tiff, ImageType.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImageAsync(string, ImageOrPrintOptions)

Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.

toImageAsync(imageFile: string, options: ImageOrPrintOptions) : Promise<void>;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.
options	ImageOrPrintOptions	Additional image creation options

Returns

Promise

Remarks

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.

toImageAsync(ImageOrPrintOptions)

Creates the chart image and saves it to a stream in the specified format.

toImageAsync(options: ImageOrPrintOptions) : Promise<Uint8Array>;

Parameters:

Parameter	Type	Description
options	ImageOrPrintOptions	Additional image creation options

Returns

The result stream

Remarks

The type of the image is specified by using options.ImageType. The following formats are supported: ImageType.Bmp, ImageType.Gif, ImageType.Png, ImageType.Jpeg, ImageType.Tiff, ImageType.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.

toImage(string)

Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.

toImage(imageFile: string) : void;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.

Remarks

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImage(string, ImageType)

Creates the chart image and saves it to a file in the specified image type.

toImage(imageFile: string, imageType: ImageType) : void;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.
imageType	ImageType	The image type in which to save the image.

Remarks

The type of the image is specified by using imageType. The following types are supported: ImageType.Bmp, ImageType.Gif, ImageType.Png, ImageType.Jpeg, ImageType.Tiff, ImageType.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImage(string, number)

Creates the chart image and saves it to a file in the Jpeg format.

toImage(imageFile: string, jpegQuality: number) : void;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.
jpegQuality	number	Jpeg quality.

Remarks

toImage(number)

Creates the chart image and saves it to a stream in the Jpeg format.

toImage(jpegQuality: number) : Uint8Array;

Parameters:

Parameter	Type	Description
jpegQuality	number	Jpeg quality.

Returns

The result stream

Remarks

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImage(ImageType)

Creates the chart image and saves it to a stream in the specified format.

toImage(imageType: ImageType) : Uint8Array;

Parameters:

Parameter	Type	Description
imageType	ImageType	The image type in which to save the image.

Returns

The result stream

Remarks

The type of the image is specified by using imageType. The following types are supported: ImageType.Bmp, ImageType.Gif, ImageType.Png, ImageType.Jpeg, ImageType.Tiff, ImageType.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

toImage(string, ImageOrPrintOptions)

Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.

toImage(imageFile: string, options: ImageOrPrintOptions) : void;

Parameters:

Parameter	Type	Description
imageFile	string	The image file name with full path.
options	ImageOrPrintOptions	Additional image creation options

Remarks

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.

Example

Saves a chart to a png file with 400 x dpi and 300 y dpi.

const { Workbook, ImageOrPrintOptions } = AsposeCells;

var options = new ImageOrPrintOptions();
options.horizontalResolution = 400;
options.verticalResolution = 300;
options.quality = 80;

var book = new Workbook(data);
var uint8Array = book.worksheets.get(0).charts.get(0).toImage(options);

toImage(ImageOrPrintOptions)

Creates the chart image and saves it to a stream in the specified format.

toImage(options: ImageOrPrintOptions) : Uint8Array;

Parameters:

Parameter	Type	Description
options	ImageOrPrintOptions	Additional image creation options

Returns

The result stream

Remarks

The type of the image is specified by using options.ImageType. The following formats are supported: ImageType.Bmp, ImageType.Gif, ImageType.Png, ImageType.Jpeg, ImageType.Tiff, ImageType.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.

Example

Saves a chart to an Uint8Array in jpeg file format with 400 x dpi and 300 y dpi.

const fs = require("fs");
const { Workbook, ImageOrPrintOptions, ImageType } = AsposeCells;

var options = new ImageOrPrintOptions();
options.setImageType(ImageType.Jpeg);
options.horizontalResolution = 400;
options.verticalResolution = 300;

var book = new Workbook(data);
var uint8Array = book.worksheets.get(0).charts.get(0).toImage(options);

toPdfAsync(string)

Saves the chart to a pdf file.

toPdfAsync(fileName: string) : Promise<void>;

Parameters:

Parameter	Type	Description
fileName	string	the pdf file name with full path

Returns

Promise

toPdfAsync(string, number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)

Saves the chart to a pdf file.

toPdfAsync(fileName: string, desiredPageWidth: number, desiredPageHeight: number, hAlignmentType: PageLayoutAlignmentType, vAlignmentType: PageLayoutAlignmentType) : Promise<void>;

Parameters:

Parameter	Type	Description
fileName	string	the pdf file name with full path
desiredPageWidth	number	The desired page width in inches.
desiredPageHeight	number	The desired page height in inches.
hAlignmentType	PageLayoutAlignmentType	The chart horizontal alignment type in the output page.
vAlignmentType	PageLayoutAlignmentType	The chart vertical alignment type in the output page.

Returns

Promise

toPdfAsync()

Creates the chart pdf and saves it to a stream.

toPdfAsync() : Promise<Uint8Array>;

Returns

The result stream

toPdfAsync(number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)

Creates the chart pdf and saves it to a stream.

toPdfAsync(desiredPageWidth: number, desiredPageHeight: number, hAlignmentType: PageLayoutAlignmentType, vAlignmentType: PageLayoutAlignmentType) : Promise<Uint8Array>;

Parameters:

Parameter	Type	Description
desiredPageWidth	number	The desired page width in inches.
desiredPageHeight	number	The desired page height in inches.
hAlignmentType	PageLayoutAlignmentType	The chart horizontal alignment type in the output page.
vAlignmentType	PageLayoutAlignmentType	The chart vertical alignment type in the output page.

Returns

The result stream

toPdf(string)

Saves the chart to a pdf file.

toPdf(fileName: string) : void;

Parameters:

Parameter	Type	Description
fileName	string	the pdf file name with full path

toPdf(string, number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)

Saves the chart to a pdf file.

toPdf(fileName: string, desiredPageWidth: number, desiredPageHeight: number, hAlignmentType: PageLayoutAlignmentType, vAlignmentType: PageLayoutAlignmentType) : void;

Parameters:

Parameter	Type	Description
fileName	string	the pdf file name with full path
desiredPageWidth	number	The desired page width in inches.
desiredPageHeight	number	The desired page height in inches.
hAlignmentType	PageLayoutAlignmentType	The chart horizontal alignment type in the output page.
vAlignmentType	PageLayoutAlignmentType	The chart vertical alignment type in the output page.

toPdf()

Creates the chart pdf and saves it to a stream.

toPdf() : Uint8Array;

Returns

The result stream

toPdf(number, number, PageLayoutAlignmentType, PageLayoutAlignmentType)

Creates the chart pdf and saves it to a stream.

toPdf(desiredPageWidth: number, desiredPageHeight: number, hAlignmentType: PageLayoutAlignmentType, vAlignmentType: PageLayoutAlignmentType) : Uint8Array;

Parameters:

Parameter	Type	Description
desiredPageWidth	number	The desired page width in inches.
desiredPageHeight	number	The desired page height in inches.
hAlignmentType	PageLayoutAlignmentType	The chart horizontal alignment type in the output page.
vAlignmentType	PageLayoutAlignmentType	The chart vertical alignment type in the output page.

Returns

The result stream

getActualSize()

Gets actual size of chart in unit of pixels.

getActualSize() : number[];

Returns

Actual size in an array(width and height). [0] is width; [1] is height.

hasAxis(AxisType, boolean)

Returns which axes exist on the chart.

hasAxis(aixsType: AxisType, isPrimary: boolean) : boolean;

Parameters:

Parameter	Type	Description
aixsType	AxisType
isPrimary	boolean

Remarks

Normally, Pie, PieExploded, PiePie,PieBar, Pie3D, Pie3DExploded,Doughnut, DoughnutExploded is no axis.

switchRowColumn()

Switches row/column.

switchRowColumn() : boolean;

Returns

False means switching row/column fails.

getChartDataRange()

Gets the data source range of the chart.

getChartDataRange() : string;

Returns

The data source.

Remarks

Only supports range.

setChartDataRange(string, boolean)

Specifies data range for a chart.

setChartDataRange(area: string, isVertical: boolean) : void;

Parameters:

Parameter	Type	Description
area	string	Specifies values from which to plot the data series
isVertical	boolean	Specifies whether to plot the series from a range of cell values by row or by column.