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.
- 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.
- 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.
Now let’s insert arrows in the flowchart.
- Again click: Insert > Shapes and then select the arrow shape from the Line section.
- 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.
- Then release the mouse and the arrow will be connected with the boxes.
If we move any connected shape then the arrow will move with the shape too, it won’t be disconnected.
- Following the same procedure add other needed arrows to the flowchart.
Now we’ll add the Yes / No text box.
- 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.
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.
- Firstly, click as follows: Insert > SmartArt.
- At this moment, select your required flowchart from the categories. I selected Converging Radial.
- Next, just press OK.
- Here’s the outlook of the flowchart, just double click on any shape and write your text.
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.
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.
- 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.
- 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.
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.
- 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.
See, I dragged toward the right direction.
And then the shape size increased in that direction.
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.