Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

ExcelScript.ChartSeriesFormat interface

Package:
ExcelScript

Encapsulates the format properties for the chart series

Remarks

Used by

Examples

/**
 * This sample gets the series format to customize fill and line properties.
 * This assumes the active worksheet has a chart.
 */
function main(workbook: ExcelScript.Workbook) {
 // Get the first chart on the active worksheet.
 const sheet = workbook.getActiveWorksheet();
 const chart = sheet.getCharts()[0];
 
 // Get series format and customize the fill color.
 const series = chart.getSeries()[0];
 const seriesFormat = series.getFormat();
 seriesFormat.getFill().setSolidColor("#B0C4DE");
}

Methods

getFill()

Represents the fill format of a chart series, which includes background formatting information.
getLine()

Represents line formatting.

Method Details

getFill()

Represents the fill format of a chart series, which includes background formatting information.

getFill(): ChartFill;

Returns

getLine()

Represents line formatting.

getLine(): ChartLineFormat;

Returns

Feedback

Was this page helpful?