Disable Text Wrapping for Data Labels of the Chart

Microsoft Excel 2013 allows users to wrap or unwrap text inside the Data Labels of the Chart. By default, the text inside the Data Labels of the Chart is in the wrapped state.

Aspose.Cells provides a DataLabels.IsTextWrapped property which you can set True or False to Enable or Disable Text Wrapping of Data Labels respectively.

The below code sample shows how to disable text wrapping for the data labels of the chart.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Load the sample Excel file inside the workbook object
Workbook workbook = new Workbook(dataDir + "sample.xlsx");

// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Access the first chart inside the worksheet
Chart chart = worksheet.Charts[0];

// Disable the Text Wrapping of Data Labels in all Series
chart.NSeries[0].DataLabels.IsTextWrapped = false;
chart.NSeries[1].DataLabels.IsTextWrapped = false;
chart.NSeries[2].DataLabels.IsTextWrapped = false;

// Save the workbook
workbook.Save(dataDir + "Output_out.xlsx");