This article explains how to find and use Excel’s free flowchart templates. Instructions apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

What to Know

  • In Excel, Insert > Illustrations > SmartArt > Process > select flowchart template > OK.You can customize your flowchart colors, shapes, and layouts.

How to Make a Flowchart in Excel

There are several flowchart designs available in Excel. The key is to look in the SmartArt Process category.

  • Open the Excel worksheet where you want to add a flowchart.
  • Go to the Insert tab.
  • In the Illustrations group, select SmartArt to open the Choose a SmartArt Graphic dialog box.
  • Choose Process in the left pane.
  • Select the flowchart template you want to use.
  • Select OK. A new basic flowchart appears on the spreadsheet.

Customize the Flowchart

Once you have the basic template, make changes to it and create the flowchart you need.

Open the Excel worksheet where you want to add a flowchart.

Go to the Insert tab.

In the Illustrations group, select SmartArt to open the Choose a SmartArt Graphic dialog box.

Choose Process in the left pane.

Select the flowchart template you want to use.

Select OK. A new basic flowchart appears on the spreadsheet.

To change the appearance of the SmartArt flowchart:

  • Select a blank area of the flowchart to activate the SmartArt Tools tabs.
  • To change the color, go to SmartArt Tools Design and select Change Colors.
  • To add text to the shapes, select a shape, type the text, then press Enter.
  • To add more shapes, select the shape to which you want to connect a new shape, go to SmartArt Tools Design, select the Add Shape dropdown arrow, and choose where you want to insert a new shape.
  • Not all Add Shape options are available for all flowcharts.
  • To change the layout of the flowchart, go to SmartArt Tools Design and choose an option from the Layouts group.
  • To change any shape in the flowchart, right-click the shape, point to Format Shape, and choose the shape you want to apply.
  • Save the worksheet when you are happy with the changes you’ve made.

Select a blank area of the flowchart to activate the SmartArt Tools tabs.

To change the color, go to SmartArt Tools Design and select Change Colors.

To add text to the shapes, select a shape, type the text, then press Enter.

To add more shapes, select the shape to which you want to connect a new shape, go to SmartArt Tools Design, select the Add Shape dropdown arrow, and choose where you want to insert a new shape.

Not all Add Shape options are available for all flowcharts.

To change the layout of the flowchart, go to SmartArt Tools Design and choose an option from the Layouts group.

To change any shape in the flowchart, right-click the shape, point to Format Shape, and choose the shape you want to apply.

Save the worksheet when you are happy with the changes you’ve made.

  • How do I import a flowchart from Excel into Word?
  • From Excel, select the flowchart and Copy it with either Home > Copy (Edit > Copy) on Mac) or pressing Ctrl + C (Command + C on Mac). Next, open Word and choose the spot you want to insert the flowchart, then select Home > Paste (Edit > Paste on Mac) or press Ctrl + V (Command + V on Mac).
  • How do I delete steps from a flowchart in Excelt?
  • Select the shape representing the step you want to delete, then press Delete. Or you can right-click the shape and select Delete from the drop-down menu.

From Excel, select the flowchart and Copy it with either Home > Copy (Edit > Copy) on Mac) or pressing Ctrl + C (Command + C on Mac). Next, open Word and choose the spot you want to insert the flowchart, then select Home > Paste (Edit > Paste on Mac) or press Ctrl + V (Command + V on Mac).

Select the shape representing the step you want to delete, then press Delete. Or you can right-click the shape and select Delete from the drop-down menu.

Get the Latest Tech News Delivered Every Day