parentSeriesGroup.setOverlap does not work as expected in Aspose Slide v19.12
I tried to create StackedColumn as stacked.
Creating chart with sample slide.shapes.addChart(ChartType.StackedColumn, 0, 0, 500, 500, true)
was okay as I expected.https://purchase.aspose.com/
But it was not stacked with my sample data.
As you can see, series overlap is zero in powerpoint.
series-overlap-is-zero.PNG (322.6 KB)
I coded s1.parentSeriesGroup.setOverlap(100 as byte)
and double check it was 100 using assert s1.parentSeriesGroup.getOverlap() == 100 as byte
.
Here’s my sample code. (Code is groovy but it works well)
def chart = slide.shapes.addChart(ChartType.StackedColumn, 0, 0, 500, 500, false)
chart.chartTitle.addTextFrameForOverriding("PoC [1-5]")
def wb = chart.chartData.getChartDataWorkbook()
def s1 = chart.chartData.series.add(wb.getCell(dataSheetNo, 0, 1, "test"), chart.type)
s1.parentSeriesGroup.setOverlap(100 as byte)
assert s1.parentSeriesGroup.getOverlap() == 100 as byte
chart.chartData.categories.add(wb.getCell(dataSheetNo, 1, 0, "[5]"))
chart.chartData.categories.add(wb.getCell(dataSheetNo, 2, 0, "[4]"))
chart.chartData.categories.add(wb.getCell(dataSheetNo, 3, 0, "[3]"))
chart.chartData.categories.add(wb.getCell(dataSheetNo, 4, 0, "[2]"))
chart.chartData.categories.add(wb.getCell(dataSheetNo, 5, 0, "[1]"))
chart.legend.position = LegendPositionType.Left
s1.dataPoints.addDataPointForBarSeries(wb.getCell(dataSheetNo, 1, 1, 18.7))
s1.dataPoints.addDataPointForBarSeries(wb.getCell(dataSheetNo, 2, 1, 61.7))
s1.dataPoints.addDataPointForBarSeries(wb.getCell(dataSheetNo, 3, 1, -27.7))
s1.dataPoints.addDataPointForBarSeries(wb.getCell(dataSheetNo, 4, 1, -12.9)
s1.dataPoints.addDataPointForBarSeries(wb.getCell(dataSheetNo, 5, 1, -0.6))
chart.chartData.switchRowColumn()