Connect with us

MS Excel

How to make graphs in Excel with various data easily

Published

on

How to make graphs in Excel with various data easily

Everyone at some point in our lives has seen the need to make some kind of graph, but we have not been able to do it, because we do not have the knowledge to achieve it and that is why we are here.

We have needed these graphs both in our work environment and in students since most projects must be analyzed with this tool because we hope that by the time you finish reading this article you will know what a graph is and how to do it, thanks to us.

What is Excel?

First of all, Excel is nothing more than a program that is part of the Microsoft company, which was released to the world on September 30, 1985, and is still actually used by most institutions and users to this day.

From this program, you can create and even have the power to manipulate all kinds of data, use various formulas and even graphics. Well, basically that is its function, to be a spreadsheet. It can also be used from Windows, macOS, Android, and iOS, making it a fairly versatile program.

Now it also allows you to make graphs with that data, but what are these graphs? These are nothing more than a graphic representation of the values ​​that we want, in order to have a visual comparison, much more understandable.

How to make graphs in Excel with various data easily

These have been used for many years because they are one of the most versatile tools in the program, and although there are other programs as an alternative, this is one of the most popular among all of them.

How to make a chart in Excel

  1. The first thing you should do is have your computer turned on and be on the desktop, there you will direct the mouse to the start menu that is in the lower-left part of the screen. You must press on it.
  2. Then look for the option called all programs and once it is in the list, scroll until you find the Microsoft office folder, if you don’t have it, you can download and install it.
  3. Then you just have to click on the Excel option and wait for the program to run.
  4. Now here you must enter the data in the corresponding boxes, or if you already have a spreadsheet with these data, just go from the desktop to the folder where the spreadsheet with said data is located.
  5. We must select the data of the boxes that we want to use, this is achieved by pressing the left mouse button and moving it between the chairs you want.
  6. As we already have our data in front of us, we must go to the horizontal menu and press “ insert “.
  7. At this point, you will be able to choose the type of graph you want from options such as pie, line, column, and even bar graphs.
  8. Once we select the rows and columns that we want, a small window will open showing the graph we choose and representing the data we select.
  9. And voila, you will be able to graphically observe all your data through a graph.

How to modify my chart?

Once we have our graphic, we can medicate it and design it to our liking, and for this, we must go to the horizontal menu and press on graphic design. From there you can choose other designs similar to the one that appeared to you.

Suppose that the circular graph model was chosen and you have followed all the steps mentioned above, but since the values ​​are very similar, it does not differ which is greater or less, for this reason, we go to ” graphic design ” and press on percentage graph.

In this way, you will be able to see the percentage of each of the data that you entered and selected for this graph. It is also possible to highlight the side of the cake with a greater or lesser percentage because you simply have to press on the section and drag it out.

Once you have made that graphic you need, you should save it to ensure the backup of the document, because you should only click on the memory icon that is in the upper left, it will ask you in which folder or device you want to save it. You choose it and select “open”. This way your work and your graphic will be completely safe.

Types of Excel charts you can use

A chart is the best way to represent the data in a spreadsheet. In the Excel toolbar in the insert option, you will find the group of different types of graphs.

Pie or pie charts

The circular or pie graphs can display data in a graph in two or three dimensions, they also serve to represent data as a percentage. Having our numerical data already selected to enter in the pie, we look in the tool panel for the option to insert and in the graphics section, we click. In this way, the cake will be displayed and with right-click on the option to add data labels, the information will be displayed in value or in percentage.

Columns or bars

The column charts ranging from rectangular, cylindrical, conical, and pyramidal. Bar charts are very similar to column charts, but in column charts, they are represented by horizontal bars.

How to make graphs in Excel with various data easily

Having the data to work on at hand, we go to the option to insert in the tools panel and click on the two- and three-dimensional column chart whatever your preference. Then you start entering the data and you will immediately have your column or bar chart.

Comparative charts

For comparative graphs, the most common graph to use is the bar or column graph, then the data to be plotted is selected, but first, the design of the graphs has been chosen, and then data begins to be inserted to begin the comparison.

Linear and with variables: ascents and descents

They are commonly used to perform sequential data representations that drive a timeline. Having our data table with the variables to work with, we look for the insert icon and click on the line graph.

Then right-click and press the option to select a data source, first, we enter variable number one and then the next variable. With respect to the given values, it will be possible to obtain lines of ascents and lines of descents, that is, the line will be an ascent if the values ​​are high or higher, while the descent line will have the lower or lower values ​​of the data to be worked on.

Main Excel formulas to create your first chart

The repeat function allows us to repeat a text a certain number of times. With this function, you create a bar chart. In a table of values ​​to work, it should be taken as a basis to graph the total of the values.

To start using the Excel formula such as repeat, we mark the equal key followed by the word repeat, we open parentheses and the assistant, where the function has two arguments, the text and the number of times.

In the text argument, we place the letter g and in the number of times we place a small operation, that is, a number divided by a thousand so that it returns a whole number. In this way, carrying out the same procedure until the table is finished.

How to make graphs in Excel with various data easily

Then we go to the letter change option, but before selecting the range to change letter, we select the webdings letter option and the font will change to a shape that will help represent a bar graph for each value.

On the other hand, to work with percentages, we open the wizard, and in the data arguments in the text we place the letter I followed by the number of times we place a value divided by a thousand, to the result we add the amperson sign (&) followed by quotation marks, space, quotation marks, and again the amperson sign (&).

Advantages of presenting data in Excel charts

Excel charts have a great advantage because they help represent data in a simplified, orderly presentation and better way.

A better understanding of the topic

Excel in its group of graphics improves the understanding of any topic to be explained, in such an effective way that anyone will understand.

Point emphasis

Each point signifies a piece of data on the graph and represents in a simple way the behavior of the data to be worked on.

Present various categories

The data to be worked on can be presented in different categories and you can represent them in the different types of graphs and you can choose the one of your preference, be it the representation of the data in both numerical or percentage form.

MS Excel

Determining Lowest and Highest Values ​​in Microsoft Excel

Published

on

Determining Lowest and Highest Values ​​in Microsoft Excel

Determining the lowest and highest values ​​requires a special formula or function that you can do with Microsoft Excel.

Determining the highest value can be done easily when there is very little data, but what about when there is a lot of data?

For that you need an Excel formula.

How to? Come on, follow this tutorial in full.

HOW TO DETERMINE THE LOWEST AND HIGHEST VALUE

To do this, the formula you can use is MAX and MIN.

As the name implies, MAX is to find the highest value, while MIN is to find the lowest value.

Meanwhile, for writing the formula, the highest value is MAX(Number1; [Number2]; …)

Number is the range of numbers for which you want to know the highest value.

Finding Lowest Value

Now, to find the lowest value you can use the formula MIN(Number1; [Number2]; …).

As usual number is a range of numbers, or the same when you look for the previous highest value.

How, very easy isn’t it? Although it looks complicated, Excel formulas will really make things easier for you.

That’s all and good luck.

Continue Reading

MS Excel

How to Use Automatic Ranking Formulas in Excel

Published

on

How to Use Automatic Ranking Formulas in Excel

The formula for finding rankings in Excel is also available for those of you who want to rank in a group.

This one formula is a formula that is quite widely used, especially in the field of education.

Well, here’s an Excel formula tutorial to find rankings.

RANKING FORMULAS IN EXCEL

There are several formulas you can use that basically have the same function for finding rankings.

And the first formula you can use is = RANK(Number;Reference;[order]).

The order in the formula is the number 0 or 1 as a ranking reference.

When you want to sort the value in descending or descending order, fill it with 0 or empty, while when you want to give the value ascending then fill it with the number 1.

But you also need to know that the formula will also give the same rank when there are the same values.

To overcome this you can use this one formula.

RANK.AVG Rumus formula

The usage is still the same, only the formula is different which becomes RANK.AVG(Number; Reference; [order])

And when you apply it and there is the same value, it will produce an average ranking of that value.

So, for an assessment, this formula is the most appropriate.

Well, if you look at the example, a value of 70 gets a rating of 7.5 while a value of 75 gets a rating of 5.5.

That’s how the ranking formula in Excel works.

That’s all and good luck.

Continue Reading

MS Excel

How to Calculate Workdays with Excel Formulas

Published

on

How to Calculate Workdays with Excel Formulas

Calculating weekdays will be very effective when you use the easiest formula in Microsoft Excel.

Most people are lazy to use Excel for their daily needs, even though this software is very useful.

Then what about the formula for finding the working day? It’s really easy. Here’s the full tutorial.

HOW TO CALCULATE WORKING DAYS

You can do this with the NETWORKDAYS formula which only counts weekdays, without weekends.

But you also need to know that the weekends here are Saturday and Sunday.

For example, if you want to determine the weekend with another day, then there is a different formula which I will discuss later.

The formula for writing is =NETWORKDAYS(Start_Date; End_Date, [Holiday_Day])

For more details, consider the following image.

How to Calculate Workdays with Excel Formulas

In this example, the number of effective working days is 87 days, where Saturday and Sunday are not included.

NETWORKDAYS.ITL

Well, for this formula you can determine the time off or weekend as needed.

The formula for writing is =NETWORKDAYS.INTL(Start_Date; End_Date; [Weekend_End]; [Holiday_Holiday])

The difference in this formula is that [weekends] are used to exclude and treat as weekdays.

If you do not fill it in, it will be considered as the previous formula.

You can also use a holiday code with a seven-character text string consisting of a combination of the text numbers 1 and 0 to represent Monday-Sunday.

So what happens is the number 1 represents holidays while the number 0 for workdays.

For example, on weekends or holidays Saturday and Sunday, the string code you are using is 0000011.

As for working days only Monday, Tuesday and Thursday or Wednesday, Friday, Saturday and Sunday off, the code used is 0010111.

That’s all and good luck.

Continue Reading
Advertisement

Latest

how to use eyebrow soap how to use eyebrow soap
Beauty and Personal Care9 hours ago

Eyebrow soap: what is it for and how to use it

SHARE Fashions and aesthetic preferences are constantly changing and evolving. Unlike a few years ago, when the eyebrows were thin...

How to Copy Paste PDF Files How to Copy Paste PDF Files
PDF Tutorials10 hours ago

2 Ways to Easily Copy Paste PDF Files, Let’s Try it!

SHARE PDF is a type of document format that can only be opened using Adobe Reader software, a browser, or...

How to Trace Unknown Numbers, Immediately Know Who How to Trace Unknown Numbers, Immediately Know Who
Life Hack11 hours ago

How to Trace Unknown Numbers, Immediately Know Who

SHARE Have you ever received an unknown call and were afraid of being scammed? It’s easy! Just track it using...

How to burn and eliminate back fat How to burn and eliminate back fat
Weight Loss1 day ago

How to burn and eliminate back fat

SHARE Do you dare to put on that low-back blouse that you saw on the sideboard or do you still...

How to Restore Emoji Like Before How to Restore Emoji Like Before
Windows 111 day ago

How to Install New Windows 11 Insider Emoji on Windows 10

SHARE As previously reported, Microsoft updated Emoji in Windows 11 starting with Windows 11 Insider Preview Build 22478, then can...

How to quickly delete thousands of emails at once in Gmail How to quickly delete thousands of emails at once in Gmail
Internet1 day ago

How to quickly delete thousands of emails at once in Gmail

SHARE Your Gmail storage capacity is dying? The only way to get around this is to quickly delete hundreds of...

How to Schedule Live on Instagram, Can Be Set Up to 90 Days How to Schedule Live on Instagram, Can Be Set Up to 90 Days
Internet1 day ago

How to Schedule Live on Instagram, Can Be Set Up to 90 Days

SHARE Live Instagram is now getting more exciting regarding the schedule live feature. A feature that allows users to schedule...

How to burn belly fat How to burn belly fat
Weight Loss2 days ago

How to burn belly fat

SHARE Over the years, bad eating habits, pregnancies, sedentary life, menopause … Many and varied are the causes that make...

Oppo Reno 7 5G on the way. There is a technical specification Oppo Reno 7 5G on the way. There is a technical specification
Phones2 days ago

Oppo Reno 7 5G on the way. There is a technical specification

SHARE Oppo Reno 7 5G is the brand’s upcoming smartphone. The technical specification of the phone has appeared on the...

Realme Watch T1 on the way. What features will the new smartwatch offer Realme Watch T1 on the way. What features will the new smartwatch offer
Gadgets2 days ago

Realme Watch T1 on the way. What features will the new smartwatch offer

SHARE Realme Watch T1 is a new smartwatch from the Chinese brand. Renders have appeared on the network and these...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap