Articles in this section
Category / Section

How to add text box shape in Excel charts?

1 min 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

Chart with TexBox

 

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

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied