Excel add-in using JavaScript API - how to get chart series source?

Question

I am writing an Excel add-in using MS Office JavaScript API

One of the tasks is to store charts in cloud and recreate them later. For creating a chart, the only function that the API is providing is

var chart = ctx.workbook.worksheets.getItem(sheetName).charts.add("pie", sourceData, "auto");

where sourceData must be am Excel range in A1:B2 format.

Unfortunately, when we iterate through all the charts in the sheet, the series object only contains values, no reference to the range is provided.

In the original VBA Excel model , the Series class had an additional Formula property, that is missing from the JS implementation.

Do you have any idea how to solve that ? How to get the series range for a chart ?

Danny122 · Accepted Answer · 2016-06-29 00:39:59Z

0

Maybe provide the 'sourceData' range as follows.

var sheet = ctx.workbook.worksheets.getActiveWorksheet();
var sourceData = sheet.getRange("A1:B6");
var chart = ctx.workbook.worksheets.getItem(sheetName).charts.add("pie", sourceData, "auto");

Placing directly as string "A1:B6" does not seem to work.

answered Jun 29, 2016 at 0:39

Danny122

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel add-in using JavaScript API - how to get chart series source?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related