How to Make an Interactive Flowchart in Excel: 7 Easy Methods

Method 1 – Create a Grid

  • Click on the upper-left corner (red-colored box) of the spreadsheet.
  • Right-click on any of the Columns.
  • Get the context menu. Select Column Width.

make an interactive flowchart in excel

  • The Column Width dialog box will pop out.
  • Type 2.14 in the box.

make an interactive flowchart in excel

  • Press OK.
  • See the grid in the worksheet.

Method 2 – Enable Snap

  • Go to the Page Layout tab.
  • Select Arrange ➤ Align ➤ Snap to Grid.
  • The feature gets activated.


Method 3 – Modify Excel Page Layout

Set the Page as per your choice and requirements. Under the Page Layout tab, you’ll get the Page Setup section. Choose your desired Margin, Orientation, etc. Choose Normal from the Margin drop-down and Portrait from the Orientation drop-down.

make an interactive flowchart in excel


Method 4 – Insert & Edit Flowchart Shapes

  • Go to the Insert tab.
  • In the Illustrations drop-down, select Shapes.
  • From the Shapes drop-down, pick your desired Flowchart Shapes.

  • Repeat the above steps to place all the shapes.
  • Click any shape to get a Shape Format; you can edit the shapes.
  • See the below figure where the input of the shapes is complete for this example.

make an interactive flowchart in excel


Method 5 – Add Text to Shapes

  • Add texts, click the desired shape, and start typing.
  • Format the texts if necessary by going to the Font, Alignment, etc. sections under the Home tab.
  • The following image demonstrates the shapes along with the texts.
  • The viewers can grasp the total concept more clearly by seeing the Flowchart.


Method 6 – Connect Shapes to Make an Interactive Flowchart

  • Join the shapes using Lines and Arrows. Arrows can distinctly show the directions of the workflow.
  • Get those in the Shapes drop-down as we demonstrated in STEP 4. Look at the image below where our shapes are connected.

make an interactive flowchart in excel


Method 7 – Attach Side Notes in Excel Flowchart

  • Insert the notes using the Text Box, which you’ll find in the Shapes drop-down.
  • The following image displays the Side Notes in the diagram.


Final Output of an Interactive Flowchart

  • Go to the Show section under the View tab to uncheck the Gridlines option.
  • The Interactive Flowchart is designed.
  • The following picture shows the final output of the Interactive Flowchart.


Download Practice Workbook

Download the following workbook to practice by yourself.


Related Article


<< Go Back to Flowchart in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo