Table Of Contents

arrow

What Is Flow Chart In Excel?

The flow chart in Excel is also known as a process chart in Excel. It represents different steps involved in a process from start to end. It has predefined shapes to represent every step involved in the process. We need to use the predefined SmartArt templates in Excel to use this chart.

Example 1-16

In this article, let us learn how to create flow charts in Excel using different methods in Excel with step by step instructions.

  • The flow chart in Excel, also known as a process chart, visually represents the various steps of a process from start to end, with predefined shapes for each step, and can be utilized using the predefined SmartArt templates in Excel.
  • To enhance the visual appeal of an Excel flow chart, it is essential to use various shapes and colors for each tab.
  • SmartArt graphics are recommended for easy shape drawing, while shapes are necessary for complex flow charts, and they should not be used.

Interpretation And Uses

Flow charts in Excel help us show the relationship between two data. So, in turn, it can help people understand the data efficiently.

We need to follow a few steps to create the flow chart in Excel. They are:

  • Create a Grid
  • Snap to Grid
  • Page Layout

Let us learn how to create flow chart in Excel.

How To Create Flow Chart In Excel?

We need to follow a few steps to create the flow chart in Excel. They are:

  • Create a Grid

We need to adjust the size of the gridlines in excel to make the shapes uniform in size. Then, the Excel worksheet would look like graph paper, so it becomes easy to draw the shapes.

  • We need to select all the cells by clicking on the triangle icon at the beginning of the column/row numbers. Keep the cursor on any column headers. Then, right-click and select the “Column Width” option in excel.
FlowChart Example 1
  • When the "Column Width" screen pops up, we must adjust the number to 2.14 (2.14 equals 20 pixels assuming that the default font is "Calibri" and font size is "11" in Excel) and click "OK."
Flow Chart Example 1-1
  • Snap to Grid

We can use this option available in Excel to snap the shape to the size of the grid. By enabling this option, whenever we insert the shape into the sheet, it will adjust the shape's size to that of the height and width of the grid.

  • Under the "Page Layout" tab in the ribbon, in the "Arrange" section, click on the drop-down below the "Align" option. Then, select the "Snap to Grid" option in the drop-down option.
Flow Chart Example 1-2
  • Page Layout

We should adjust the page layout of the sheet by setting the page break, margins, and orientations if we want to take the printout of the flow chart or we want to copy it to other applications like Word because it would be difficult to set the layout once the Excel flow chart is built.

We can set the page's orientation as either "Portrait" or "Landscape" based on the flow of the diagram. For example, if the process flow is horizontal, we need to set the page for "Landscape" mode.

Now, begin with building the Excel flow chart using the shapes.  As we have already, normally, the start and end shapes will be "oval" shapes. To draw the shapes,

  • In the "Illustrations" section, we must first select the "Shapes" drop-down under the "Insert" tab. The drop-down gives the options of all the shapes available, then choose the shape we need for the Excel flow chart and insert the shape on the worksheet.
Flow Chart Example 1-3

To start with, let us insert the oval shape. Then, select the shape, keep the cursor, and drag it using the mouse to the size we want to see.

Flow Chart Example 1-4
Flow Chart Example 1-5

The above figure shows that the shape's size is adjusted and set within the gridlines as we have enabled the "Snap to Grid'' option. It will get changed while we start drawing the shape. When the shape is expanded or contracted, it will adjust to the nearest gridline.

  • To add text to the shape, we must right-click and select the "Edit Text" option in the list.
Flow Chart Example 1-6
  • Insert the text in shape. We can align the text by using the text "Alignment" options.
Flow Chart Example 1-7

We need to insert the next shape to proceed with the next step. Insert the next shape right below the "START." We can use the rectangle shape to show the stage where there is only one option to proceed further, and the diamond shape can be used when we have two or more options to proceed further.

Flow Chart Example 1-8

The next step is to connect the shapes. Select the connector lines from the "Shapes" option and draw between the shapes to connect the shapes.

Connector lines

Once the connector is selected, keep the cursor on the shape, and we can see the connecting dots in shape.

Flow Chart Example 1-9

Now, we must start drawing the line by dragging the mouse from any of the connecting dots and joining it with the connecting dot of the other shape. The connecting dots of the next shape can be seen while drawing the line close to the shape.

Flow Chart Example 1-10

Keep adding the shapes one after the other as per the steps involved in the process.

Flow Chart Example 1-11

As we mentioned earlier, the diamond shape will be used where multiple options are involved. For example, in the above image, we can see the flow of the chart showing the different options associated with the diamond-shaped icon.

Each diagram shows only the step to be followed to complete the process. But for a clear understanding of the process, we can add additional information using the text box.

To add a text box,

  • Go to the Insert Ribbon tab in excel and click the "Text box" from the “Text” Section.
Example 1-12
  • Now, we must insert the text box by keeping the cursor in place and dragging it using the mouse. Then finally, click inside the box to enter the text.
Example 1-13
  • Remove the outline by selecting the "Format Shape" (Do right click on the box for the option) and select "No Fill" from the "Format Properties."
Format Shape

Again, we can use an oval shape to show the end of the process.

FlowChart Example 1-14
  • Remove gridlines by unchecking the "Gridlines" box in the "View" tab to make the chart look better.
Example 1-15

Like this, the flow chart looks after completing all the steps.

Example 1-16

We can format the shape of each step:

  • Select the shape we like to format, go to the "Format" tab in the ribbon, click on the drop-down option in the "Shape Styles" section, and select the format.
flow chart excel Example 1-17

Examples

Example #1 - Create Flow Chart Using Shapes (Step-By-Step)

Firstly let us build a flowchart of one popular flow chart, i.e., the organizational hierarchy chart. Below is the flow of communication in the organization.

President > Departmental Heads > Senior Manager > Manager > Team Leaders > Team Members.

It 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.

  1. We must first remove gridlines from the worksheet.

  2. Then, go to the Insert tab - Shapes - Flowchart - Rectangular shape.


    Flowchart Example 1

  3. Let us draw this first.


    Flowchart Example 1-1

    Note: To fit column and row end, we must hold the "ALT" key and adjust.

  4. After that, we must right-click and select "Edit Text."


    Flowchart Example 1-2

  5. Then, type the word "President."


    Flowchart Example 1-3

  6. This shape is not looking great. Therefore, under the "Format" option, we can change the format of the shape, as shown in the below image.


    Flowchart Example 1-4

  7. Now, the first position in the organization is over. Under "President," four departmental heads will come. For this, we must draw a straight line arrow.


    Flowchart Example 1-5

  8. We need to draw one horizontal line for all the departmental heads.


    Flowchart Example 1-6

  9. Now, we need to insert four more arrow lines.


    Flowchart Example 1-7

  10. Insert four more rectangular boxes under each arrow.


    Flowchart Example 1-8

    Note: We have added four departments. We can alter it as per the requirement.

  11. .Once the department heads' boxes are drawn, draw four more arrows and four more rectangular boxes for "Senior Manager."


    Flowchart Example 1-9

  12. . Under "Senior Manager," "Team Leader" will appear. Then, draw four more arrows and four more rectangular boxes for "Team Leader."


    Flowchart Example 1-10

  13. .Under each "Team Leader," four executives will come. But, first, we must draw one straight vertical line under each "Team Leader," as shown in the below image.


    Flowchart Example 1-11

  14. .We must draw four horizontal arrows for each vertical straight line. Therefore, we must draw 16 horizontal arrows.


    Flowchart Example 1-12

  15. . We must insert 16 text boxes in front of newly drawn horizontal arrows. For example, for the first box, type "Executive 1." For the second box, type "Executive 2." For the third box, type "Executive 3." And for the fourth box, type "Executive 4."


    Flowchart Example 1-13

  16. . So, now our flow chart for an organization is done. The flow of communication is clear in this chart. Each position in the organization is aware of whom they should contact to communicate their messages.


    Flowchart Example 1-14

Example #2 - Create Business Flow Chart Using Smart Arts (Step-By-Step)

We have seen the steps for creating a typical Excel flow chart using shapes. Using SmartArt can make the flow chart look beautiful. The SmartArt flow chart is already predefined. If we need anything extra, we need to make arrangements.

In this example, we will explain establishing a new company.

  • Step 1: We must first go to Insert - SmartArt.
Flowchart Example 2
  • Step 2: Under the SmartArt, select "Process." Scroll down and select the "Repeating Bending Process."
Flowchart Example 2-1
  • Step 3: Now, we have a default flow chart.
Example 2-2
  • Step 4: The advantage here is we have pre-drawn shapes. We must type "Business Entity Type: Private Limited" for the first box.
Example 2-3
  • Step 5: The next step is the "Registration Process."
Example 2-4
  • Step 6: Then, obtain the "Company Identification Number (CIN)."
Example 2-5
  • Step 7: The fourth step is to create a website for the company.
Example 2-6
  • Step 8: After that, we must hire employees from different departments.
Example 2-7
  • Step 9: We have two more steps to enter, but we do not have any shapes. So, we must select any one shape and paste it.
Example 2-8
  • Step 10: Now, we have inserted two more boxes. Type "Purchase Software" and "Rules for Employees" in the new boxes.
Example 2-9

Example #3 - Design Flow Chart Using Excel SmartArts (Step-By-Step)

Now, we have all the processes in a flow chart. So let's design the SmartArt now.

  • Step 1: First, we must select the "FlowChart Smart Art."
  • Step 2: Two more tabs will appear in the ribbon as soon as we choose them. Select "Design."
Example 3
  • Step 3: Choose " Change Colors " under the "Design” tab, and choose "Change Colors."
Example 3-1
  • Step 4: Change the color of the SmartArt as per wish.
Example 3-2
  • Step 5: Change the flow chart style under the "Design" tab.
Example 3-3

Example #4 - Using SmartArt Graphic

The flow chart can be created using Excel's readily available "SmartArt Graphic."

  • We must first select the "SmartArt Graphic" in the "Illustrations" section under the "Insert" tab.
Example 2
  • Now, select the diagram as per the requirement and click "OK."
Flow chart excel eg 2-1
  • After selecting the diagram, we must enter the text in the "Text Box."
Flow chart eg 2-2

The flow chart looks like as given below:

Flow chart eg 2-3

We can add the shape to the existing diagram. We can move up/down the shape in the "Design" tab by selecting the diagram.

Flow chart eg 2-4

Also, we can add shapes to the existing ones.

Flow chart 2-5

You can download this Flowchart Examples Excel template here – Flowchart Examples Excel Template

Important Things To Note

  • We must use different shapes to create a flow chart in Excel to give visual effects.
  • We must provide different colors to each tab while creating an Excel flow chart to make it more attractive.
  • We must use the SmartArt graphics for an easy drawing of shapes.
  • In the case of more complex flow charts, we must use shapes. Do not use SmartArt graphics.

Frequently Asked Questions

1. How to make an interactive flow chart in Excel?

To make an interactive flow chart, one must select "Shapes" from the "Insert" ribbon, then select the "Flowchart" group. Then, choose an element, right-click, and choose "Edit Text" from the pop-up menu. From the "Format" ribbon, select a style and color scheme.

2. Is Word or Excel better for flowcharts?

MS Excel is a user-friendly and efficient flowcharting tool, ideal for mapping processes. However, it is up to creators and process owners to choose which program to use for creating process maps.

3. Why are flowcharts useful?

Flowcharts are diagrammatic representations of problem solutions, providing a breakdown of essential steps. They aid in designing and planning processes by identifying these steps and providing a larger picture of the process.