Search code examples
exceloffice-jserrorbarexcel-web-addins

How to specify positve and negative values for custom error bars

Thanks the API office.js, I'm displaying a bar chart. Now I want to add custom error bar on each data bar.

The following image shows the result obtained using Excel vba:

enter image description here

But in the spec of the API office.js, I don't find any information about how to set the positive and negative values for an custom error bars.

On Excel, it can be done using the following graphics options:

enter image description here

How can I set negative and positive values for an custom error bar with the API office.js ?

Solution

  • Unfortunately, Office.js doesn't have the API to set custom value for error bars in Excel API set 1.13 and before.