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

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.


Download Practice Workbook

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


2 Ways to Make a Yes No Flowchart in Excel

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 Cross Functional Flowchart in Excel (3 Easy Ways)


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.

Here’s my completed flowchart.

Insert SmartArt to Make a Yes No Flowchart

Read More: How to Create a Workflow in Excel (3 Simple Methods)


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.


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

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo