Microsoft Excel is a spreadsheet software program generally used to organize and format large amounts of data, but it also packs a diverse shapes gallery to make flowcharts!
A SmartArt graphic is the go-to illustration to create any diagram in Excel. However, you need a more compelling flowchart for collaboration and communication .
In this guide, we’ll walk through the function of flowcharts, how to create a flowchart in Excel, and two Excel alternatives to make your flowcharts come to life. (Spoiler: the two alternatives are in the same software!)
What is a flowchart?
A flowchart is a diagram made of shapes connected by arrows to visualize a workflow, process, or any decision-making procedure . Flowcharts are for everyone because unlike text-heavy documents, they condense information so the audience can digest the information faster.
Flowcharts turn ideas into thought-out actions to solve problems and ultimately, increase productivity because things run smoothly. Think about any event you’ve encountered at some point at your organization, for example. It could be new hire onboarding , requesting PTO, or organizing a project kickoff meeting . These events have a process in place so everyone consistently takes the right steps towards success. Flowcharts help the person creating these processes visualize the scope, sequence, stages, and stakeholders involved.
Bonus: Diagram software !
Basic shapes used in Excel flowcharts
It’s not necessary to be well-versed in flowchart programming. All you need to know are the basic building blocks to make your flowchart easy to understand. The four main flowchart shapes we’ll use for this tutorial are:
Created in Microsoft Excel
flowchart digram symbols and definitions | Symbol | Function | How to Add | | --------- | ------------------------------------------------------ | ----------------------------------------------------------- | | Oval | Terminal: the start point and end point of a flowchart | Insert tab > Illustration > Shapes > Flowchart > Terminator | | Rectangle | Process: represents a single step in the procedure | Insert tab > Illustration > Shapes > Flowchart > Process | | Diamond | Decision: represents a decision action | Insert tab > Illustration > Shapes > Flowchart > Decision | | Arrow | Arrow: connects shapes to show the relationship | Insert tab > Illustration > Shapes > Flowchart > Arrow |
Ready to create a flowchart of your own? Choose one of your ideas or tasks and follow along with our step-by-step guide to create this flowchart! ⬇️
Created in Microsoft Excel
How to create a flowchart in Excel with custom shapes
Note: In this tutorial, we use Microsoft Excel for Mac Version 16.60. The steps and features may look different if you’re on another version.
Excel is a large application with hundreds of functions. The two most important functions to use and speed up your flowchart build are: copy and paste. So rather than adding shapes one by one to your spreadsheet, we’ll format the shapes first. Then you can copy and paste the shapes into your flowchart process. Here we go!
Related: Learn how to create a flowchart in Google Docs .
1. Add the terminator, process, and decision flowchart shapes
Go to the Insert tab > Illustration > Shapes > Flowchart > select a shape > click at the top of the spreadsheet to add.
Created in Microsoft Excel
2. Adjust the flowchart shape sizes
We want to add text inside the shapes, so let’s make them bigger. Select one of the shapes > press Command + A on your keyboard to select all shapes > hold Shift > go to a shape’s corner and drag to expand all three flowchart shapes.
Created in Microsoft Excel
3. Customize each flowchart shape
We’ll use the copy and paste function to customize the shapes, but there’s a handy Format icon to help us with this!
- Double click inside the Process shape to reveal a cursor, label the shape Process, and center the text
- Change the font name and font size to your preference
- Select the Process shape > click the Format icon under the Home tab > click on the other shapes to paste the format
- Label the diamond shape Decision and the oval shape Terminator
Created in Microsoft Excel
Next, select background and font colors for each shape. Click on a shape > go to the Shape Format tab > Shape Fill and Text Fill
Created in Microsoft Excel
Pro Tip: To remove the shape outline for a cleaner look, select all shapes > Shape Format tab > Shape Outline > No Outline
Created in Microsoft Excel
4. Begin adding your flowchart steps
With your fully customized (and consistent) shapes, copy and paste the Excel flowchart shape to map out your steps!
Created in Microsoft Excel
5. Insert Tab to add the connectors to show each shape relationship
Go the Insert tab > Shapes > Lines > Arrow.
Created in Microsoft Excel
Use the green circles as a guide to draw the arrows and connect the shapes.
Created in Microsoft Excel
6. Add a title to your flowchart
Delete the shapes at the top of your spreadsheet and add a title.
Tip: For a cleaner look, remove the gridlines in your Excel flowchart. Go to the Page Layout tab > uncheck the View box under Gridlines
Created in Microsoft Excel
Bonus: Best Flowchart Software Tools for Mac
8. Save your Excel flowchart as a template
Go to File > Save as Template. Name your flowchart template and click Save. (Double check the File Format is set as Excel Template.)
Created in Microsoft Excel
There you have it! You now know how to make a flowchart in Excel! We have other Microsoft Office resources and recommendations if you’re looking for other alternatives to improve your planning needs. ⬇️ How to Create a Timesheet in Excel and bring your best ideas to life!