Creating a Flowchart in Excel

Have you been tasked with creating a flowchart to document a business process? Some companies invest in expensive, specialized software that builds flowcharts for you with just a few points and clicks. Other businesses prefer to use a tool which they already have, and in which the employees have already been trained: Excel.

Plan Out Steps

Because a flowchart’s purpose is to outline the logical order in which events must occur, the decisions which must be made, and the outcomes of those decisions, most people find it easier to build a flowchart if they first invest a few minutes organizing their thoughts. A flowchart with haphazard, poorly thought-out steps accomplishes little good.

So take a few minutes to make notes. The format isn’t important; just be sure to list each step in the process and identify each decision and possible outcome.

Set up Items

For each step in your outline, add a flowchart element in Excel.

1. From the Insert ribbon, choose Shapes.
2. The resultant list of shapes is organized into general groups. Scan down until you find the Flowchart group.
3. Choose an element.
4. To add text, right-click the element and, from the pop-up menu, choose Edit Text.
5. From the Format ribbon, select a style and color scheme.

Fred Pryor Seminars_Excel Flow Chart 1

When you have finished with that element, add another element for the next item in your outline, continuing until you have each step on the screen.

Note the shape of each flowchart item. The shape tells the reader what function each step fulfills in the overall scheme. You’ll want to follow the standard function of each shape, for using the elements in nonstandard ways risks confusing your audience.

A few of the more common elements are:

  • The beginning or end of your flowchartFred Pryor Seminars_Excel Flow Chart 2
  • A process to carry out, such as a workflow procedureFred Pryor Seminars_Excel Flow Chart 3
  • A predefined process, such as a commonly repeated subroutineFred Pryor Seminars_Excel Flow Chart 4
  • A data source, such as a database table or other inputFred Pryor Seminars_Excel Flow Chart 5
  • A decision, such as evaluating whether a prior process completed properly. The connectors flow out from each corner of the diamond, depending on the outcome of the decisionFred Pryor Seminars_Excel Flow Chart 6

Arrange Elements

After you have placed each element:

• To align the items neatly in a column, select multiple elements by holding the SHIFT key while clicking each item, then choose Align Center from the Format ribbon.

Fred Pryor Seminars_Excel Flow Chart 7

• To space the items out evenly, select multiple elements, then choose Distribute Vertically from the Format ribbon.

Fred Pryor Seminars_Excel Flow Chart 8

• Double-check the sizes for consistency. Make all elements the same height and width to up the polished and professional look of your flowchart. You can adjust each element’s height and width by selecting the item and modifying the parameters on the Format ribbon.

Set up Connectors

From the Insert ribbon, choose Shapes and add either a straight line or an elbow line.

• Use a straight line to connect two elements in direct sequence.
• Use an elbow line when the connector must bend, such as to return to a prior step after a decision element.

Fred Pryor Seminars_Excel Flow Chart 9

Next Steps

Excel offers additional types of elements for flowcharts, along with an endless variety of formatting options. Feel free to explore and see what you can do!