If there is something that should be essential throughout the comprehensive training of a person, it is knowing how to handle Excel tools . And not only to know how to make a graph , we refer to all the possible functions that are within the scope of the possibilities to learn. Either in its installed version or in its online version, where you can easily create spreadsheets .
In Excel the possibilities are multiple aspects , such as advanced line graphs , or intermediate aspects such as double axis graphs , but covering all aspects in these very modest lines cannot be possible, so we are going to focus on one topic particular.
We are talking of course about how to make a diagram or scatter chart in an Excel spreadsheet . And for this we are going to break it down below.
Conceptualization of the chart or scatter diagram
Much can be said on this subject, but it will be necessary to adhere to the mathematical field in order to give a correct conceptualization. The element consists of two words, graphic and the word dispersion.
Now, the graph will be a representation in a Cartesian coordinate axis where different values are going to be reflected for their study and / or analysis, for its part the so-called dispersion, refers to the degree to which values are distanced in sets, but valued according to its average value.
From where it is analyzed, that a scatter graph will be a representation of two variables, within a Cartesian graph, where a conglomerate of data is going to be analyzed, which are similar to each other by a common point.
To create a scatter chart or diagram in Excel
Excel is famous for greatly facilitating the tasks of users, that is why we refer at the beginning to the importance of knowing how to use its tools, being able to make or create a graph or scatter diagram in an Excel spreadsheet , it will be extremely Simple, since Excel already has everything pre-configured by just appending information.
Excel must first be opened to access your spreadsheet . At the top in the data table space, within the “insert” section, we are going to press.
We are going to refer to the space devoted to graphics, there you will see their category, distributed according to the functions to be carried out, we will choose one within the space that says “dispersion” . It can be chosen with the style of lines or the style of markers.
Once chosen, the interface will show the model that has just been selected, which will insert it into the spreadsheet for editing.
The respective edition of the scatter graph is at the discretion and need of the Internet user who is preparing it. Excel is extremely easy to handle, since it only remains for the user to fill the graph with the information they have.
How to put together a correct graph or scatter diagram, to represent it with the graphical tools of Excel?
As mentioned, in the Excel spreadsheet, a scatter diagram pre-designed by Excel was attached to only be filled in by the user, now, we must know what values to append and the details to consider.
In the first instance, it is to clarify the relationship between the two variables , which will be represented on the axes of “X” and “Y”.
The values of the variables must be determined, it is crucial that both values to be compared are connected with the mutual temporal reality, that is, that their values are both from the same date to be compared.
The variable must be positioned in the precise place, in general measures, the independent variable is assigned to the Cartesian axis of “X”.
The determination of the correlation coefficient will be the one who shapes or molds the interaction between variables on the Cartesian axis, luckily Excel takes care of all this. And we only have to apply and run the tools that are requested by the interface.
That’s how easy it is to make a diagram or scatter chart in an Excel spreadsheet. Well, as it has been made clear, it is one of the many graphs that can be created using the great tool that is Excel . In this way, it is not necessary to perform calculations, just enter the values and that’s it.
