Everyone at some point in our life has seen the need to do some sort of graph, but we haven't been able to do it, because we don't have the knowledge to make it and that's why we're here.
We needed these graphs both in our work environment and in students, as most projects have to be analyzed with this tool , because we hope that when you have finished reading this article you will know what a chart 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 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 graphs. Well, basically this is its function, to be a spreadsheet. Yup can also be used by Windows, MacOS, Android and iOS , making it quite a versatile program.
Now it also allows you to graph that data, but what are these charts ? These are nothing more than a graphical representation of the values 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 alternative programs, this is one of the most popular of them all.
How to create a chart in Excel
- The first thing you should do is turn on your computer and find yourself on the desktop, there you will direct the mouse to the start menu which is in the lower left part of the screen. You have to press on it.
- Then look for the option called All Programs and once it's in the list, scroll down until you find the folder Microsoft Office , if you don't have it, you can download and install it.
- Then you just have to click on the option Excel and wait for the program to run.
- Now here you have to enter the data in the corresponding boxes, or if you already have a spreadsheet with this data, just go from the desktop to the folder where the spreadsheet with that data is located.
- We have to select the data of the boxes we want to use, this is achieved by pressing the left mouse button and moving it between the chairs you want.
- Since we already have our data in front of us, we have to go to the horizontal menu and press " insert ".
- At this point you will be able to choose the type of chart you want from options such as pie, line, column, and even bar charts.
- Once we have selected the rows and columns we want, a small window will open showing the graph we choose and which represents the data we select.
- And voila, you will be able to graphically observe all your data through a chart.
How to edit my chart?
Once we have our graphics, we can medicate it and design it to our liking, and for this we have to 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.
Let's assume that the circular chart template has been chosen and that you have followed all the steps mentioned above, but as the values are very similar, it does not differ whether it is greater or less, for this reason we go into " graphic design "and click on the percentage graph.
In this way you will be able to see the percentage of each of the data you entered and selected for this chart. You can also highlight the side of the pie with a higher or lower percentage because you just need to press on the section and drag it out.
Once you have created the graphics you need, you have to save it to ensure backup of the document, because you just have to click on the memory icon located at the top 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 graphics will be completely safe.
Types of Excel charts you can use
A chart is the best way to represent data in a spreadsheet. In the Excel toolbar in the insert option you will find the group of several types of charts .
Pie or pie charts
I circular or pie charts they can display data in a graph in two or three dimensions, they also serve to represent the data as a percentage. Having already selected our numerical data to insert in the pie, we look for the option to insert in the tool panel and click in the graphics section. This will display the pie and right click on the option to add data labels, the information will be displayed in value or percentage.
Read How to use my mobile as a security camera? - Very easy
column or bar
- histograms they vary from rectangular, cylindrical, conical and pyramidal. Bar charts are very similar to histograms, but in histograms they are represented by horizontal bars.
Having the data to work on at hand, let's go to the option to insert in the toolbox and click on the two- and three-dimensional histogram whatever your preference. Then you start entering data and you will immediately have your column or bar chart.
For the comparative charts, the most common chart to use is the bar or column chart, so you select the data to plot, but first you have chosen the design of the charts and then you start entering the data to start 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 variables to work with, we look for the insert icon and click the graph to lines.
Then right click and press the option to select the data source, we first insert the variable number one and then the next variable. Compared to the given values, it will be possible to get rise lines and descent lines, i.e. the line will be a rise if the values are high or higher, while the descent line will have the lowest or lowest data values to work on. .
Main Excel formulas for creating your first chart
La repeat function it allows us to repeat a text a certain number of times. With this function you create a bar chart. In order for a table of values to work, it should be taken as the basis for graphing the total of values.Read How to put a WATER MARK in Power Point - Quick and easy (example) - See how it's done
To start using the formula in Excel as you repeat, we mark the same key followed by the word repeat, open the brackets 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 in the number of times we place a small operation, that is, a number divided by a thousand so that it returns an integer. In this way, performing the same procedure until the end of the table.
So we go to the letter change option, but before selecting the range to change letter, we select the letter webdings option and the character will change into a shape which will help to represent a bar chart for each value.
Instead to work with percentages we open the wizard and in the arguments of the data in text we put the letter I followed by the number of times we put 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
I Excel charts have a big advantage , because we help to represent the data in a simplified, orderly and better way presentation.
Better understanding of the topic
Excel in its group of graphs improves understanding of any topic to be explained, so effectively that anyone will understand it.
Point Emphasis Point
Each point indicates a data on the graph and it simply represents the behavior of the data to work on.
Present various categories
The data to work on can be presented in different categories and you can represent them in the different types of graphs and you can choose the one you prefer, be it the representation of the data in both numerical and percentage form.