How to make a chart in Excel

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.

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.
  1. 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 where you can choose other designs similar to the one that appeared to you.

Suppose that the pie chart 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 click 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.

 

Leave a Comment

Scroll to Top