Why won't ChartSeries.getPoints() work in Excel for web?

Question

I have a workbook I've created in Excel for web with just a single column chart and some sample data to its side

Using office scripts, I'm trying to set the color of an individual column on the chart with this code:

function main(workbook: ExcelScript.Workbook) {

    const sheet = workbook.getWorksheet("Sheet1")
    const chart = sheet.getChart("Chart 1")
    const series = chart.getSeries()[0]

    const i = 3
    const point = series.getPoints()[i]
    point.getFormat().getFill().setSolidColor("red")
}

When I run this in Excel for web, I get the error ChartSeries getPoints: There was an internal error while processing the request.

But if I save this workbook locally and run this script on my desktop Excel, it works as expected. How can I make this code run in Excel for web?

Answer 1

Hi @Austin

Questions about TypeScript development in general, you may also post in: https://stackoverflow.com/questions/tagged/office-scripts

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---