ExcelScript.ChartSeriesFormat interface

Remarks

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()

getFill(): ChartFill;

getLine()

getLine(): ChartLineFormat;