Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Create a Voting System in Microsoft Excel?

Date:2020-11-27 Author:Sandra

We all know the US election in 2020. Joe Biden defeats Donald Trump to win presidency. The results of this election were obtained through voting by the American people. Ok, let’s end here, we don’t talk about politics, we only talk about Microsoft tips. In addition to the US election, you may also need to vote in your, family, class, or the community to make some decisions.

Today, the author will share with you guys how to create a voting system just in Excel. There may be many steps in this tutorial, but the author recommends that you open an Excel sheet to have a try when you reading this. Let’s get to start.

Step1:Insert Pin Buttons (Form Control)

How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?

If we entering the number of votes manually can be troublesome in the area D2:D6, so we use the pin button to control this area. Take the button we just inserted as an example. Let’s use the button to control the D2 value.

Step2:Right-click the button and choose Format Control. Click D2 cell as Cell Link in the Control window.

How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?

Now you can copy and paste to get 5 Pin Buttons to represent each candidate. (Remember to change the buttons’ Cell Link.)

How to Create a Voting System in Microsoft Excel?

Step3:Insert a Chart

Select the cell area and insert a chart. You can choose the chart style you like.

How to Create a Voting System in Microsoft Excel?

Right-click the chart and click on Sent to Back, then you can adjust the position of the previous 5 Pin Buttons up to the chart.

How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?

If you have finished all the previous steps, this can already meet the needs of daily voting. In the next part, the author will teach you some more difficult operations. These steps can help you visually see who the top three are.

Step1: Create Two New Columns

Copy the following line of code into E3.

=IFERROR(VLOOKUP(D3,LARGE($D$3:$D$7,ROW($D$1:$D$3)),1,0),0)

Remember to press Ctrl+ Shift+ Enter to run this formula, otherwise it will not succeed. This formula allows the top three votes appear, and the rest will show 0 in the column E.

Copy the following line of code into F3.

=IF(D3-E3>0,D3,0)

This formula allows the top three votes to show 0, and the rest will show votes in column F.

How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?

Step2: Insert a New Chart

You need to insert a new chart, just select column C, column E, and column F to insert a chart. Then adjust the chart like before.

How to Create a Voting System in Microsoft Excel?

Step3: Insert Text Box

Insert text boxes above the corresponding column of the chart. Then enter the corresponding cell value.

How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?
How to Create a Voting System in Microsoft Excel?

Congratulations, you have completed all the steps. The three candidates with the highest votes will have blue bars. Others will be orange.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *