I'm creating a chart that has a single series and a single point in the series. An example is:
chart.setSourceData('sheet!A1:B1', false), where the categories are in column A.
This method call is creating 2 series and is treating the value in B1 as the category value and the series point value. The chart is a barClustered.
Is there a way to work around this issue?
The setSourceData method is a helper method that tries to do some of the logic that Excel does when you select a range and insert a chart but in some cases it differs. You could just directly create the series like this.
var series = chart.seriesCollection().add(); series.name(new $.ig.excel.SeriesName(sheet, "Sheet1!A1")); series.values(new $.ig.excel.SeriesValues(sheet, "Sheet1!B1"));