Category / Section
                                    
                                How to add text box shape in Excel charts?
                
                
                    2 mins read
                
            
    Text box shape can be added into a chart using AddTextBox property in IChartShape of XlsIO as shown in the below code sample.
C#
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
 
IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
 
// The first worksheet object in the worksheets collection is accessed.
IWorksheet worksheet = workbook.Worksheets[0];
IChartShape chart = workbook.Worksheets[0].Charts[0];
 
// Adding TextBox to chart.
chart.TextBoxes.AddTextBox(1, 1, 100, 200);
 
// Setting position for TextBox.
chart.TextBoxes[0].Top = 850;
chart.TextBoxes[0].Left = 765;
 
// Adding text to TextBox.
chart.TextBoxes[0].Text = "Yearly Profit”;
 
// Save the workbook.
workbook.SaveAs("Output.xlsx");
 
// Close the workbook and dispose the engine.
workbook.Close();
excelEngine.Dispose();
VB
Dim excelEngine As ExcelEngine = New ExcelEngine
Dim application As IApplication = excelEngine.Excel
 
Dim workbook As IWorkbook = application.Workbooks.Open(“sample.xlsx”)
 
'The first worksheet object in the worksheets collection is accessed.
Dim worksheet As IWorksheet = workbook.Worksheets(0)
Dim chart As IChartShape = workbook.Worksheets(0).Charts(0)
 
'Adding TextBox to chart.
chart.TextBoxes.AddTextBox(1, 1, 100, 200)
 
'Setting position for TextBox.
chart.TextBoxes(0).Top = 850
chart.TextBoxes(0).Left = 765
 
'Adding text to TextBox.
chart.TextBoxes(0).Text = " Yearly Profit”
 
' Save the workbook.
workbook.SaveAs("Output.xlsx”)
 
' Close the workbook and dispose the engine.
workbook.Close()
excelEngine.Dispose()
Chart with TextBox

The sample which illustrates the above behavior can be downloaded here.
