Resize Chart's Data Label Shape To Fit Text with Node.js via C++

Excel provides the Resize shape to fit text option for chart’s data labels in order to increase the size of the shape so that the text fits inside it.

How to Resize Chart’s Data Label Shape To Fit Text in Microsoft Excel

This option can be accessed on the Excel interface by selecting any of the data labels on the chart. Right‑click and select the Format Data Labels menu. On the Size & Properties tab, expand Alignment to reveal the related properties, including the Resize shape to fit text option.

How to Resize Chart’s Data Label Shape To Fit Text Using Aspose.Cells for Node.js via C++

In order to mimic Excel’s feature of resizing data label shapes to fit the text, the Aspose.Cells APIs have exposed a Boolean property DataLabels.isResizeShapeToFitText(). The following piece of code shows a simple usage scenario of the DataLabels.isResizeShapeToFitText() property.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "source.xlsx");

// Create an instance of Workbook containing the Chart
const workbook = new AsposeCells.Workbook(filePath);

// Access the Worksheet that contains the Chart
const sheet = workbook.getWorksheets().get(0);

for (let c = 0; c < sheet.getCharts().getCount(); c++) {
    // Access the Chart
    const chart = sheet.getCharts().get(c);

    for (let index = 0; index < chart.getNSeries().getCount(); index++) {
        // Access the DataLabels of indexed NSeries
        const labels = chart.getNSeries().get(index).getDataLabels();

        // Set ResizeShapeToFitText property to true
        labels.setIsResizeShapeToFitText(true);
    }

    // Calculate Chart
    chart.calculate();
}

// Save the result
workbook.save(path.join(dataDir, "output_out.xlsx"));