How to add text to the flowchart connector or flowline

Excel 2016
You often need to add some text or labels to the connectors when you create the process flowchart, process map, business flowchart, data flow diagrams, and UML activity diagrams. Unlike other free and commercial diagram drawing packages, Microsoft Office shapes provide extremely rich text formatting features.
Flow chart connectors with texts in Excel 365

To add labels to the connector or flowline, do the following:

1.   Add the text box to the flowchart

To add the text box to the flowchart, do one of the following:

  • On the Insert tab, in the Text group, click the Text Box button:
    Text Box in Excel 365
  • Select the connector to which you want to add text, and then on the Shape Format tab, in the Insert Shapes group, click the Text Box button:
    Insert Shapes group in Excel 365

Excel adds the text box:

Textbox for Flow chart connector in Excel 365

2.   Add the text box to the flowchart

To add the text to the text box, just double-click on it and type the text:

Textbox with text for Flow chart connector in Excel 365

3.   Format text box

To add a more presentable look to the text box, do the following:


Center the text in the text box

Center text in Flow chart connector in Excel 365

To position the text in the middle center of the text box, do the following:

   1.   Select the text box.

   2.   Do one of the following:

  • Right-click the text box, then select Format Shape... in the popup menu:
    Format Shape popup in Excel 365

    On the Format Shape pane, do one of the following:

    • On the Text Options tab, in the Textbox group, in the Text Box section, choose Middle Centered from the Vertical alignment dropdown list:
      Format Shape text - Middle Centered in Excel 365
    • On the Shape Options tab, in the Size & Properties group, in the Text Box section, choose Middle Centered from the Vertical alignment dropdown list:
      Format Shape - Middle Centered in Excel 365
  • On the Home tab, in the Alignment group, select both Middle Align and Center buttons:
    Alignment - Middle Centered in Excel 365

Format the text box to hide its filling and borders

Hide background text in Flow chart connector in Excel 365

To format the text box filling and borders, select it, then do one of the following:

  • Right-click the text box, then select Format Shape... in the popup menu. On the Format Shape pane, on the Shape Options tab, in the Fill & Line group:
    • In the Fill section, select No fill,
    • In the Line section, select No line:
    No fill and no ontline shape in Excel 365
  • On the Shape Format tab, in the Shape Styles group:
    • Click the Shape Fill button, then choose No Fill from the Shape Fill dropdown list:
      No Fill shape in Shape Format Excel 365
    • Click the Shape Outline button, then choose No Outline from the Shape Outline dropdown list:
      No Outline shape in Shape Format Excel 365

Align the text box to the center of the flowline

Align text in Flow chart connector in Excel 365

To align the text box to the center of the connector vertically or horizontally, do the following:

   1.   Select both elements - the text box and the connector (flowline).

   2.   On the Shape Format tab, in the Arrange group, click the Align button.

From the Align dropdown list, select the appropriate item:

Align shapes in Excel 365

See how to organize shapes in Excel for more details.

Notes:

  1. Check that you haven't lost the connection between the connector and the shape.
  2. Text boxes are like other shapes, and you can add connectors to link them together or link to other shapes:
Linked text box in Flow chart connector in Excel 365

See also this tip in French: Comment ajouter le texte ou étiquettes au connecteur dans l'organigramme.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.