Working in Excel greatly simplifies our work, because the mathematical module recalculates all changes in a split second. It is very convenient! If you are just starting to understand the capabilities of this program, you can learn how to use charts to visually see changes in your data. Once you learn this, you can solve this problem in a couple of minutes.
Instructions
Step 1
When we examine the graph of a function, it is necessary to know how to prepare the data. In the first line, starting from column B, write the X values at the points where we will examine the graph of the function. For example, starting from -3 with a step of 0.2 to 3 inclusive. We need to consider the graph of the function y = (x + 2) / x ^ 2. Then it is important to write down the calculation formula correctly. For column B, it will look like this: = (B1 + 2) / B1 ^ 2. It remains only to copy this formula to all cells of the second line under the entries of the values of X. It is clear that X cannot be equal to zero, since it is impossible to divide by 0. Therefore, be careful, because Excel cannot draw graphs tending to infinity, and will simply connect the previous and next points with a solid line.
Step 2
Let's select the prepared records, preferably together with the column labels. For example, if your data is collected every month for several companies, then the names of companies, months and the data itself must be selected at the same time. Then in the menu we press "Insert" and in the submenu select "Diagram …".
Step 3
The most crucial moment comes, as it is necessary to choose the type of diagram. The most commonly used chart is the "Graph" (in older versions it is called "Linear"), especially when the indicators are taken annually, monthly or every day. Chart "Graph" allows us to build diagrams of changes with an arbitrarily long period of time, while the drawing itself is understandable even for beginners. When examining function plots, the Scatter plot is best. If we need to see the share of specific indicators in the total mass, then the "Pie" or "Donut" chart is well suited. We choose, for example, "Graph". Click "Next".
Step 4
In a new dialog box, we can see how our diagram will look. If the plot of the data is not clear, try changing the series so that the chart is calculated not in rows, but in columns. Having chosen the best option, you can click "Finish", since in the next dialog boxes we will only be able to customize the names of columns, charts, colors, as well as indicate whether to show the chart on a separate sheet, or in the same place where the data itself is located.
