How to Make a Flowchart in Excel: Shapes, Grid & SmartArt

To make a flowchart in Excel, draw shapes from Insert → Shapes and hold Alt as you drag, so each edge snaps to a cell border. Then join the shapes with arrows from the Lines group, which stay attached as you move things around. For a simple straight-line process, Insert → SmartArt → Process is even faster.

Quick steps

Menu paths are for Excel in Microsoft 365 on Windows.

1. Select the whole sheet and give rows and columns the same pixel size, so the cells are square.
2. Choose Insert → Shapes and pick a shape from the Flowchart group.
3. Hold Alt while you drag, so the shape snaps to the cell grid. Then type its label.
4. Pick Line Arrow or Connector: Elbow Arrow and drag between connection dots on two shapes.
5. Add "Yes" and "No" labels beside each decision's exits.
6. Tidy up with Shape Format → Align, then group the finished chart.
7. Set a print area, scale it to one page and hide gridlines with View → Gridlines.

Why build a flowchart in Excel?

Excel's grid is its hidden advantage. Every cell is a fixed unit, so shapes can snap to exact positions without rulers or guides. You can also keep process details, such as owners, durations or systems, in columns beside the chart.

The trade-offs show up later: spreadsheets aren't built for presenting, and large charts get fiddly. Consider another tool if the chart will be presented, runs to dozens of steps or needs an animated version.

How do I set up the grid so shapes line up?

Make the cells square

Default cells are wide rectangles, and Excel measures column width in characters but row height in points. Square cells turn the sheet into graph paper:

1. Click the Select All triangle at the top-left corner of the sheet.
2. Drag any row border to the height you want and note the pixel value in the tooltip.
3. Drag any column border until its tooltip shows the same pixel value.

Because the whole sheet is selected, every row and column changes together. You can also type exact values in Home → Format → Row Height and Column Width.

Snap shapes to the cells

You have two ways to snap:

• Hold Alt while you drag or resize a shape. Its edges jump to the nearest cell borders.
• Turn on Shape Format → Align → Snap to Grid to make snapping the default. With it on, holding Alt lets you place a shape freely instead.

Snap to Shape, in the same menu, lines edges up with nearby shapes.

Now plan the chart in cells. For example, make every process box 6 columns wide and 2 rows tall, with 2 empty cells between steps. Shapes built to the same cell counts line up automatically. Keep View → Gridlines ticked while you build.

How do I add flowchart shapes in Excel?

Choose Insert → Shapes. On a narrow window, Shapes may sit inside an Illustrations button. Find the Flowchart group and hover over a shape to see its name, such as Flowchart: Decision.

Click a shape, then hold Alt and drag over the cells. Select the shape and type its label. The alignment buttons on the Home tab center text inside a shape, just as they do in cells.

A few habits save time:

• Type exact sizes in the Shape Format → Size boxes, so every step matches.
• Duplicate a shape with Ctrl+D, or hold Ctrl and drag it.
• Style one shape, then right-click it and choose Set as Default Shape. New shapes will match.

Link shape text to cells

This trick only works in Excel. Keep your list of steps in a column, one step per cell. Select a shape, click in the formula bar, type =, click the cell that holds the step and press Enter. The shape now shows that cell's text and updates when the cell changes.

It pays off when step names change often. You edit the list, and every box follows.

How do I connect the shapes with arrows?

Unlike Word, Excel doesn't need a drawing canvas for connectors to stay attached.

1. Choose Insert → Shapes and pick Line Arrow for straight runs or Connector: Elbow Arrow for right-angle turns.
2. Hover over the first shape until connection dots appear.
3. Drag from a dot to a dot on the next shape and release.
4. Move one of the shapes to test. An attached arrow stretches to follow.

To draw several arrows in a row, right-click the arrow in the Shapes menu and choose Lock Drawing Mode. Press Esc to stop. Drag the small yellow handle on an elbow connector to move its bend. Once one arrow is styled, right-click it and choose Set as Default Line.

How do I show decisions and Yes/No branches?

Draw a Flowchart: Decision diamond and write a short question inside, such as "Over budget?" Then draw two connectors out of it: one from the bottom point and one from a side point.

Connectors can't hold text, so label the exits in one of two ways:

• Text boxes. Choose Insert → Text Box, draw a small box and type "Yes" or "No". Set Shape Fill to No Fill and Shape Outline to No Outline. The labels move with the chart once you group it.
• Cells. Type "Yes" or "No" into the cell beside the arrow. It's fast and sits on the grid, but it stays put if you drag the chart.

For loops, run an elbow connector from the side of a later step back to an earlier one, around the outside of the chart.

Can I use SmartArt for an Excel flowchart?

Yes, for straight sequences. Choose Insert → SmartArt, click Process, and pick Basic Process, Vertical Process or Basic Bending Process. Type the steps in the text pane; Enter adds a step. Restyle it with Change Colors on the SmartArt Design tab.

SmartArt can't branch, but Excel can break it into ordinary shapes. Select the graphic and choose Convert to Shapes from the Reset group on the SmartArt Design tab. The conversion is one-way, so copy the graphic first. Its arrows become plain shapes rather than connectors, so replace them before you rearrange anything.

Can I draw swimlanes in Excel?

Yes, and the rows do most of the work. Give each team a band of rows and fill it with a light color. Type the team name in the first column of its band. Then draw each step inside its owner's band. Our workflow diagram guide explains how to assign lanes and handoffs.

How do I keep the flowchart intact when the sheet changes?

Shapes can shift or stretch when you insert rows or resize columns beneath them. Once the chart is finished:

1. Turn on Home → Find & Select → Select Objects and drag a box around the chart. Group it with Shape Format → Group → Group.
2. Click the small arrow in the corner of the Shape Format → Size group to open the format pane.
3. Under Properties, choose Don't move or size with cells.

To prevent accidental edits, protect the sheet with Review → Protect Sheet. Shapes stay locked unless you allow editing objects.

How do I print or export an Excel flowchart?

1. Select the cells underneath the chart and choose Page Layout → Print Area → Set Print Area.
2. For a wide chart, choose Page Layout → Orientation → Landscape.
3. Under Page Layout → Scale to Fit, set Width and Height to 1 page.
4. Check the result with View → Page Break Preview or File → Print.

Gridlines don't print unless you tick Page Layout → Sheet Options → Gridlines → Print. Untick View → Gridlines to hide them on screen as well.

To share a fixed copy, save a PDF with File → Save As and choose PDF as the file type. For an image, select the grouped chart, click the arrow next to Home → Copy and choose Copy as Picture. Pick As shown on screen and Picture, then paste it into Word, PowerPoint or an email.

What happened to the Visio Data Visualizer add-in?

Older tutorials recommend Microsoft's Visio Data Visualizer add-in, which drew a flowchart from a table of steps. Microsoft has retired it. The add-in left the store in early 2026, and its service shut down on March 2, 2026.

Diagrams made with it no longer load or refresh, though the table data stays in the workbook. For data-driven diagrams, Microsoft now points users to Visio itself. What you get depends on your plan (as of September 2026).

Flowchart symbols you'll need

Excel's Flowchart group includes every standard symbol. You'll use these most:

• Terminator (rounded ends): start and end.
• Process (rectangle): a step someone performs.
• Decision (diamond): a question with labeled exits.
• Data (parallelogram): an input or output, such as an invoice.
• Document (wavy bottom edge): a step that produces a document or report.

Our flowchart symbols guide explains the rest, with examples.

Faster option: generate the flowchart with AI

If your steps already sit in a column, you're most of the way to a finished chart. Infogiph's AI flowchart maker can handle the layout:

1. Copy the steps and decisions from your sheet and paste them into Infogiph, adding what happens on each branch in plain English. You can also upload a screenshot or a photo of a sketch.
2. Infogiph generates an animated, fully editable flowchart, usually in about 5–15 seconds.
3. Refine it by chatting, or edit labels, icons, colors and layout on the canvas.
4. Export a PNG or SVG. In Excel, choose Insert → Pictures → Place over Cells → This Device, so the image floats above the grid.

SVG stays sharp when you resize it. The inserted image isn't editable as Excel shapes, so make changes in Infogiph and export again.

The free plan includes 5 AI generations in total, a one-time allowance that doesn't reset. It also includes the full editor and unlimited exports in PNG, SVG, GIF and MP4. Free exports carry a small Infogiph watermark. You sign in with Google, and no credit card is needed.

FAQ

How do I make square cells in Excel?

Select the whole sheet, then drag a row border and a column border until both tooltips show the same pixel value. Column width and row height use different units, so matching pixels is the simplest method.

Why do my flowchart shapes move when I insert rows?

Their properties let them move or resize with the cells beneath them. Group the chart, open the format pane from the Shape Format → Size group, and choose Don't move or size with cells under Properties.

Can Excel create a flowchart from data automatically?

Microsoft's tool for that, the Visio Data Visualizer add-in, was retired in March 2026. Your options now are Visio's own data-driven features, where your plan includes them, or pasting the steps into an AI flowchart generator.

Keep going

• How to make a flowchart in Word covers the same shapes inside a document, including charts that span pages.
• Start from an editable chart: the expense approval flow template or the order fulfillment process template.