How to Make a Yes No Flowchart in Excel (2 Useful Methods)

Get FREE Advanced Excel Exercises with Solutions!

While using Excel for educational or business purposes, drawing flowchart is a too common task. There are smart ways in Excel to do it, especially Excel has a lot of customization by which we can format the flowchart as we want. This article will provide you with 2 quick methods to make a yes-no flowchart in excel with sharp steps.


How to Make a Yes No Flowchart in Excel: 2 Useful Ways

1. Insert Shapes to Make a Yes No Flowchart in Excel

First, we’ll use the flowchart shapes from the Insert ribbon to make a yes-no flowchart. There are a lot of different kinds of shapes that we can use for our particular operations.

Steps:

  • Click as follows to insert a shape: Insert > Shapes.
  • Then select the required shape for the Flowchart Shapes.

  • Soon after you will get the shape in your sheet, double-click on it, and type your text.

Insert Shapes to Make a Yes No Flowchart in Excel

  • Following the same way, insert more shapes as you required. Also, you can just copy and paste a shape using CTRL + C and CTRL + V.

Insert Shapes to Make a Yes No Flowchart in Excel

Now let’s insert arrows in the flowchart.

  • Again click: Insert > Shapes and then select the arrow shape from the Line section.

Insert Shapes to Make a Yes No Flowchart in Excel

  • After that, keep the cursor on the circle shape of an inserted box then you will get a plus sign.
  • Then just click and drag your mouse to the next shape.

Insert Shapes to Make a Yes No Flowchart in Excel

  • Then release the mouse and the arrow will be connected with the boxes.

Insert Shapes to Make a Yes No Flowchart in Excel

If we move any connected shape then the arrow will move with the shape too, it won’t be disconnected.

Insert Shapes to Make a Yes No Flowchart in Excel

  • Following the same procedure add other needed arrows to the flowchart.

Insert Shapes to Make a Yes No Flowchart in Excel

Now we’ll add the Yes / No text box.

  • For that, click as follows: Insert > Text > Text Box.

Insert Shapes to Make a Yes No Flowchart in Excel

  • Later, you will get a text box like the image below, type Yes or No where required.
  • Then drag and place it close to the arrow.

  • In the same way, insert text boxes for the other arrows.

And now see, our flowchart is completed.

Read More: How to Create a Flowchart in Excel


2. Insert SmartArt to Make a Yes No Flowchart

This method will apply the SmartArt command option from the Insert ribbon to draw a flowchart in Excel. The difference from the first method is- here you will get a much more built-in complete flowchart for particular applications including arrows and symbols. You will need to insert text just.

Steps:

  • Firstly, click as follows: Insert > SmartArt.

Insert SmartArt to Make a Yes No Flowchart

  • At this moment, select your required flowchart from the categories. I selected Converging Radial.
  • Next, just press OK.

Insert SmartArt to Make a Yes No Flowchart

  • Here’s the outlook of the flowchart, just double click on any shape and write your text.

Insert SmartArt to Make a Yes No Flowchart

Now we’ll have to add Yes / No.

  • Follow the 10th step from the first method to insert a text box.
  • Later, just type the text and place it near the related arrow.

Here’s my completed flowchart.

Insert SmartArt to Make a Yes No Flowchart

Read More: How to Create a Swimlane Flowchart in Excel


How to Format Yes No Flowchart in Excel

Excel has huge customizations to change the formats of the flowchart. Like, we can change the shape, color, text color, text font, alignment, etc. Let’s see how to change some major formats.


Format Shape Color

First, we’ll learn how to change the color of a shape.

Steps:

  • Select the shape.
  • Then from the Shape Format tab, pick any color from Shape Styles. I chose yellow.

Now you see, the color is changed.


Format Text Color

We can change the text color too from the same Shape Format ribbon.

Steps:

  • Select the shape whose text color you want to change.
  • Later, click the Text Fill option from the WordArt Styles.
  • Then choose the desired color from the appeared menu. I chose red.

How to Format Yes No Flowchart

Now have a look, Excel has changed the text color successfully.


Format Shape Size

Finally, we’ll see how to change the size of a shape. For that, we won’t need any command, the mouse is enough to do it.

Steps:

  • When we click on any shape, we get eight small circles around the shape as shown in the image below. Just click and drag any circle, the shape size will change along with that direction.

How to Format Yes No Flowchart

See, I dragged toward the right direction.

And then the shape size increased in that direction.


Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.


Conclusion

I hope the procedures described above will be good enough to make a yes-no flowchart in Excel. Feel free to ask any question in the comment section and please give me feedback. Visit ExcelDemy to explore more.


Related Article


<< Go Back to Flowchart in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo