Chart label reposition dynamically

Question

function main(workbook: ExcelScript.Workbook
) {
let selectedSheet = workbook.getWorksheet("Sheet1");
//get the current used range and lastRow
let myUsedRange = selectedSheet.getUsedRange();
let lastRow = myUsedRange.getAddress();
let radarchart = selectedSheet.addChart(ExcelScript.ChartType.radarFilled, selectedSheet.getRange(lastRow));
radarchart.getSeriesNameLevel[0]
radarchart.getTitle().setText('Score by Section')
radarchart.getAxes().getValueAxis().getFormat().getFont().setSize(1)
radarchart.getDataLabels().setShowValue(true);
let radarchartimage = radarchart.getImage()
radarchart.delete();
return [radarchartimage]
}

@Yutao Huang - MSFT
The Chart values are overlapping chart labels .
How to reposition them dynamically so that it does not overlap

Answer 1

@Vignesh Babu Sundararajan

This seems like a radar chart rendering issue. I'd suggest submitting a frown through the feedback button in Excel Online.

As a temporary workaround, maybe you can consider somehow concatenating the operation name and the score into a single column to be used as the "Category Labels", then hide the data labels (radarchart.getDataLabels().setShowValue(false)). Something like this (I used the sample data from another post of yours :) ):

Answer 2

Great Thanks

I did the same work around !