EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Flowchart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Flowchart

By Madhuri ThakurMadhuri Thakur

Flowchart-in-Excel

Excel Flowchart (Table of Contents)

  • Flowchart in Excel
  • How to Create a Flowchart in Excel?

Flowchart in Excel

Flow Chart is used to create a flow of any process from start to end. Flow Chart in Excel can be created by using different shapes available in the Insert menu’s Shape option. Every flow chart starts and ends with the Rectangle, and a one-directional arrow represents the directions of the flow of data. If there is any process or function happening, then that we usually show with Diamond shape. Every shape has a different meaning when we use them in Flow Chart. Always give a name to each step and shape to make it more meaningful.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

How to Create a Flowchart in Excel?

Excel provides the in-built shapes or symbols through which we will do some preliminary formatting and manual adjustments while creating a flowchart in excel.

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

It includes the below steps for creation.

Format a Grid

Although this step is an option, it will help us create uniform shapes if you follow this step. We change the column width for all the columns to be equal to the default row height, which helps us create all shapes more uniform.

For this, follow below steps:

Step 1 – Select all the cells in the spreadsheet by clicking on the box in the extreme upper left corner.

Step 2 – Right-click on any column heading, and it will open a drop-down list of items. Click on Column Width.

Step 3 – By default, it’s showing 8.43. Change this to 2.14, which is equal to 20 pixels. Click on OK.

flowchart example 1-1

Enable Span

This process helps to resize shapes and is easy to place on the grid.

For this, follow below steps:

Step 1 – Go to the Page Layout tab. Click on Align option under Arrange section, as shown in the below screenshot.

flowchart example 1-2

Step 2 – It will open a drop-down list. Click on the Snap to Grid option from the list.

flowchart example 1-3

Set the Page Layout Setting

It is required to set up the page layout for a flowchart so that you know your boundaries before creating the flowchart in excel.

Click on the page layout tab and set the Margins, Orientation, and Size options under Page Setup to change the settings. Then, refer to the below screenshot.

flowchart example 1-4

Add Shapes to Flowchart in Excel

Follow the below steps to add the first shape to your excel flowchart:

Step 1 – Go to the INSERT tab. Click on the Shapes option under the Illustrations section. It will open a drop-down list of various sections having a different style of options. Refer to the below screenshot.

flowchart example 1-5

Step 2 – Click on any shape under the Flowchart section and drag it on the worksheet. We are dragging the rectangle on the worksheet, which refers to the process stage.

  • As we have enabled the Snap to Grid option, this shape automatically snaps the gridlines when you draw it.

flowchart example 1-6

Add More Flowchart Shapes in Excel

After drawing the first shape on your worksheet, an additional FORMAT tab opens, as shown in the below screenshot.

You can create more shapes using a drop-down under the Insert Shapes section.

flowchart example 1-7

You can write the text inside the shape after clicking inside the shape area.

flowchart example 1-8

Add Connector Lines Between Shapes

Once you have created more than one shapes on the worksheet, you need to add those shapes with a connecting line.

For this, follow below steps:

Step 1 – Go to the INSERT tab and click on the Shapes option under the Illustrations section or Go to the new Format tab and click on the Insert Shapes dropdown. Choose the line which you want to use as a connector between shapes. Refer to the below screenshot.

flowchart example 1-9

Step 2 – After clicking on the line symbol, a plus icon will appear on the worksheet. Now click on the first shape you want to connect and click on the connection point from where you want the line to start and drag that line to the next shape and release the mouse when the connector establishes well.

flowchart example 1-10

Step 3 – You can format the line connector and add text also as shown in the below screenshot.

Line Connector

Step 4 – Now, we add more shapes with connecting lines, as shown in the below screenshot.

flowchart example 1-12

For Making Notes in Excel Flowchart

You can use Callout for making notes, and it looks different in appearance.

For this, follow below steps:

  • Go to the INSERT tab and click on the Shapes option or go to the new FORMAT tab. Click on any shape under the Callout section, as shown in the below screenshot.

Shapes Callout

Drag the callout on the worksheet and place it at the desired position. Add text to it as we did in the above screenshot.

Dragging the Callout

Formatting of Flowchart in Excel

You can format the shapes, connecting lines, text, etc., of the flowchart.

Follow the below steps for this:

  • Select all the shapes together by using the SHIFT key and click on the FORMAT tab. Click on the drop-down arrow under the Shape Styles section, as shown in the below screenshot.

Shape Styles section

  • It will open a list of various options. Choose any of them as per the requirement, and it will add the theme to the shape.

Shape Themes

  • In the same way, you can format the connecting lines and texts.
  • You can align the text by using Alignment and format the text by using Font under the HOME tab.

Things to Remember about Excel Flowchart

  • While choosing the Theme on the Page Layout tab and changing the Margins, Orientation and Size, it will change the fonts and color themes and changes the height, and column width, which can change the shapes are available on that page.
  • You can also draw a flowchart in excel by using the Smart ART option available under the Illustration section in the INSERT tab.

Recommended Articles

This has been a guide to Flowchart in Excel. Here we discuss how to create a Flowchart in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles to learn more –

  1. Bubble Chart in Excel
  2. Chart Wizard in Excel
  3. Interactive Chart in Excel
  4. Marimekko Chart Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Flowchart Excel Template

EDUCBA

Download Flowchart Excel Template

EDUCBA

डाउनलोड Flowchart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more