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

How to Create Automatic Serial Numbers in Excel

Published

on

How to Create Automatic Serial Numbers in Excel

There are several ways to create automatic serial numbers in Microsoft Excel that you can use to help with any given job.

Starting from the manual method, there are various ways, really.

And for you beginners who may just be getting to know Microsoft Excel, we will explain how to do it.

Go ahead, here’s the complete tutorial.

HOW TO CREATE SEQUENTIAL NUMBERS IN EXCEL

Creating a serial number is very easy, and you don’t need to do it manually.

How to Create Automatic Serial Numbers in Excel

For the automatic method, you can write only two numbers, then select both, and a dot will appear on the bottom right side.

Press and hold the dot then drag downwards.

By doing this, you no longer need to use the very old manual method.

Using Excel Fills

In addition to this method, you can use another method, namely Excel Fill.

First, write only one number, then select it and go to the Home menu – Fill – Series as below.

How to Create Automatic Serial Numbers in Excel

A new menu will appear, and fill in as needed. Because you want to make the number downward, we choose Columns, Linear, and in the stop value fill in the last number you want.

How to Create Automatic Serial Numbers in Excel

Well, that’s easy, isn’t it? You can use all methods according to your needs.

That’s all and good luck!

Continue Reading

MS Excel

How To Find & Replace Feature in Microsoft Excel

Published

on

How To Find & Replace Feature in Microsoft-Excel

Excel has a feature called Find & Replace, this feature will help you when searching for data according to its name.

So you no longer need to search manually one by one. Because this feature will find words or data according to what you input.

But it’s not only limited to searching for data or words, but you can also use it to replace data.

How to? Here’s the full tutorial.

EXCEL’S FIND & REPLACE FEATURE

To use the Find feature, you can click the Home menu – Find & Select Find like this,

How To Find & Replace Feature in Microsoft-Excel

A pop-up menu will appear and you can simply type the word or data you want to search for and then press Find Next.

How To Find & Replace Feature in Microsoft-Excel

Excel will automatically display the data quickly.

Or, if you want an even faster way, you can use the Ctrl+F shortcut to open the menu.

Change Words or Data Quickly

In addition to searching, you can also use this feature to replace data or words very quickly.

The trick is to press Ctrl + F and the same menu will appear as before. But here select Replace like this.

How To Find & Replace Feature in Microsoft-Excel

On the menu, when the word you want to change is in the Find what and Replace with a column for replacement words or data.

Then Replace All to replace all these words or you can select Replace to replace only one data.

How, after knowing this, the use of Microsoft Excel becomes easier, dong.

Of course, this feature makes it very easy for you to process your data, especially if you experience a lot of data input errors.

Continue Reading

MS Excel

How to Set Column and Row Size in Microsoft Excel

Published

on

How to Set Column and Row Size in Microsoft Excel

The easiest way to adjust the size of columns and rows in Microsoft Excel is this way. Guys, curious, right?

Before We tell you how usually you will need to set the column and row sizes when you are inputting data but the number of characters exceeds the thickness or height of the cell.

In other words, the data you input only appears partially.

Then how to solve it? Here’s the full tutorial.

HOW TO SET COLUMN AND ROW WIDTH

This is very easy for you to do, even those who are just learning will immediately be able to. You can directly use the mouse to expand or adjust the size.

The trick is to press, hold and drag the mouse on the boundary of each column or row like this.

How to Set Column and Row Size in Microsoft Excel

Easy, right? The same goes for when you want to resize rows, yes. The difference is, you need to hover your mouse over the row of lifts on the left.

Column Width Features

In addition to this method, there is one other method that requires several steps.

First, select all or the area you want then go to the Home menu – Format – Column Width like this.

How to Set Column and Row Size in Microsoft Excel

After the pop-up menu appears again, you just enter the desired value, then the column will automatically have the same size.

This second method is perfect for those of you who want to set the same column and row sizes in Excel without any difference.

But if you want a fast one, you can use the first method, both are the same depending on your needs.

Continue Reading
Advertisement

Latest

How To Use Dummy Text Lorem Ipsum in Microsoft Word How To Use Dummy Text Lorem Ipsum in Microsoft Word
MS Word13 hours ago

How To Use Dummy Text Lorem Ipsum in Microsoft Word

SHARE How To Use Dummy Text Lorem Ipsum in Microsoft Word How to quickly make Dummy Text Lorem Ipsum in...

How to Quickly Enlarge and Reduce Fonts in Word How to Quickly Enlarge and Reduce Fonts in Word
MS Word13 hours ago

How to Quickly Enlarge and Reduce Fonts in Word

SHARE You can increase and decrease fonts in Microsoft Word very quickly, you don’t even need to change your font...

How to Create Automatic Serial Numbers in Excel How to Create Automatic Serial Numbers in Excel
MS Excel13 hours ago

How to Create Automatic Serial Numbers in Excel

SHARE There are several ways to create automatic serial numbers in Microsoft Excel that you can use to help with...

How To Find & Replace Feature in Microsoft-Excel How To Find & Replace Feature in Microsoft-Excel
MS Excel13 hours ago

How To Find & Replace Feature in Microsoft Excel

SHARE Excel has a feature called Find & Replace, this feature will help you when searching for data according to...

How to Set Column and Row Size in Microsoft Excel How to Set Column and Row Size in Microsoft Excel
MS Excel14 hours ago

How to Set Column and Row Size in Microsoft Excel

SHARE The easiest way to adjust the size of columns and rows in Microsoft Excel is this way. Guys, curious,...

How to Delete Columns and Rows in Microsoft Excel How to Delete Columns and Rows in Microsoft Excel
MS Excel14 hours ago

How to Delete Columns and Rows in Microsoft Excel

SHARE You can delete Excel columns and rows to tidy up the data or worksheets that you are managing. By...

How to Copy Writing Format in Microsoft Word How to Copy Writing Format in Microsoft Word
MS Word2 days ago

How to Copy Writing Format in Microsoft Word

SHARE This time, how to copy the writing format in Microsoft Word into tutorial material that you will enjoy on...

How to Show Calculator Features in Microsoft Word How to Show Calculator Features in Microsoft Word
MS Word2 days ago

How to Show Calculator Features in Microsoft Word

SHARE How to display the calculator feature in Microsoft Word is really easy for you to try! For those of...

How to Add Columns and Rows in Excel How to Add Columns and Rows in Excel
MS Excel2 days ago

How to Add Columns and Rows in Excel

SHARE How to add columns and rows in Excel is an important and mandatory thing for you to know, especially...

How to Create a Table in Microsoft Excel How to Create a Table in Microsoft Excel
MS Excel2 days ago

How to Create a Table in Microsoft Excel

SHARE How to create a table in Excel is very easy because basically, Microsoft Excel consists of a table and...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap