Data Labels Error in Pivot Table when using Office Scripts

Question

Hi, I used the "Record Actions" function to create a Pivot Table and Chart. It went well and created my scripts. However, when I ran the scripts, an internal error was thrown on the following line of code:

chart_1.getSeries()[0].getDataLabels().setShowValue(true);

I need to have the data labels displayed on my chart. The vertical axis is of course an alternative. But its just not very useful since I'm creating a radar chart. Can someone help on this?

Thanks in advance,

Keith.

Answer 1

Dear Keith,

Welcome to our forum here.

I did a test and I can reproduce the issue in your environment. I can create a pivot table via Office Scripts but the error comes when running the chart label command. I checked the code and I think that the code may be correct.

As we have a specific support channel Q&A forum-Office Scripts coping with Office Scripts related issues, I suggest you post a new thread there to see if there are some code issues when using the feature.

Sorry for that our category may have limited resources on further investigating the source code page.

Thanks for your understanding and have a nice day!

Cliff