js excel addin charts.add method issue

71 Views Asked by At

some time ago(unfortunately I can not say how long exactly) I start to get an issue with the charts function - here is an example from script lab which exactly reproduces what I have in my project: when I create a chart by button from the tagline (chart 2) everything is alright, but when I try to create a chart by call charts.add function from js code I get a kind of "empty diagram" (chart 1)(it can be fixed by press column/row button from the tagline, but it is not appropriate solution for me). it happens just for a diagram with a two-column range and just in the web version of excel, but unfortunately, all my diagrams have a two-column range and the web version is the main point of my add-in. Please help me find out any appropriate solution that I can implement and use from the code and help me understand if it is a bug in js add-in API.

enter image description here

1

There are 1 best solutions below

1
On

I also tried and cannot repro the issue, so can you ensure clear local js cache and have a try? Also please try other browser you don't use before.