How to Create Flow Chart in Excel? (with Examples)
Flow chart in excel is an also known as process chart in excel, it is used to represent different steps involved in a process from start to end, it has predefined shapes to represent every step involved in the process, to use this chart we need to use the predefined templates of smart art in excel.
Example #1 – Create Flow Chart using Shapes (Step by Step)
Firstly let’s build a flow chart of one of the popular flow chart i.e. organizational hierarchy chart. Below is the flow of communication in the organization.
President > Departmental Heads > Senior Manager > Manager > Team Leaders > Team Members.
This is the typical organization flow chart we usually get to see. In this article, we will learn to create a flow chart in excel using shapes.
- Step 1: Remove gridlines from the worksheet.
- Step 2: Go to Insert > Shapes > FlowChart > Rectangular shape.
- Step 3: Let’s draw this first.
Note: In order to fit column and row ends hold the ALT key and adjust.
- Step 4: Right-click and select EDIT text.
- Step 5: Type the word, President.
- Step 6: This shape not looking great. Under Format change the format of the shape as shown in the below image.
- Step 7: Now the first position in the organization is over. Under him there are 4 departmental heads will come. For this draw straight line arrow.
- Step 8: Now we need to draw one horizontal line for all the departmental heads.
- Step 9: Insert 4 more arrow lines.
- Step 10: Insert 4 more rectangular boxes under each arrow.
Note: I have added 4 departments. You can alter as per your requirement.
- Step 11: Once the department heads boxes drawn. Draw 4 more arrows and 4 more rectangular boxes for Senior Manager.
- Step 12: Under Senior Manager, Team Leader will appear. Draw 4 more arrows and 4 more rectangular boxes for Team Leaders.
- Step 13: Under each team leader 4 executives will come. For this first draw one straight vertical line under each team leader as shown in the below image.
- Step 14: For each vertical straight line draw 4 horizontal arrows. Totally draw 16 horizontal arrows.
- Step 15: Insert 16 text boxes in front of newly drawn horizontal arrows. For first box type Executive 1, for second box type Executive 2, for third box type Executive 3, and for fourth box type Executive 4.
So now our flowchart for an organization is done. A flow of communication is clear with this chart. Each position in the organization in aware whom they should contact to communicate their messages.
Example #2 – Creat Business FlowChart Using Smart Arts (Step by Step)
We have seen the steps for creating a typical excel flowchart using shapes. Using Smart Arts will make the flowchart looks beautiful. Under the Smart Arts flowchart is already pre-defined if we need anything extra we need to make arrangements.
In this example, I will explain the process involved in establishing a new company.
- Step 1: Go to INSERT > Smart Art.
- Step 2: Under the Smart Art select Process. Scroll down and select the Repeating Bending Process.
- Step 3: Now we have a default flowchart.
- Step 4: The advantage here is we have pre-drawn shapes. For the first box type Business Entity Type: Private Limited
- Step 5: The next step is to Registration Process.
- Step 6: Next obtain Company Identification Number (CIN).
- Step 7: the Fourth step is to create a website for your company.
- Step 8: Hire employees from different departments.
- Step 9: Now we have 2 more steps to enter but we don’t have any shapes left. So select any one shape and paste.
- Step 10: Now we have inserted two more boxes. Type purchase software and rules for employees in the new boxes.
Example #3 – Design FlowChart Using Excel Smart Arts (Step by Step)
Now we have all the process in a flowchart. Let’s design the smart art now.
- Step 1: Select the FlowChart Smart Art.
- Step 2: As soon as you select two more tabs will appear in the ribbon. Select Design.
- Step 3: Under design select Change Colors.
- Step 4: Here change the color of the smart art as per your wish.
- Step 5: Change the style of the flowchart under the Design tab.
Things to Remember
- Use different shapes to give visual effects for creating a flowchart in Excel.
- Give different colors to each tab while creating an excel flowchart just to make it more attractive.
- Use smart arts for easy draw of shapes.
- In the case of more complex flowcharts use shapes do not use smart arts.
This has been a guide to FlowChart in Excel. Here we discuss the steps of creating a flowchart in excel Using Shapes and SmartArt along with practical examples and downloadable excel template. You may learn more about excel from the following articles –