How to plot a chart in Word using a spreadsheet?

Those who are just starting to get acquainted with the real capabilities of a text editor from Microsoft, want to talk about its functionality as much as possible. Word is a program that, having studied thoroughly, any user understands that there is no need to install additional software to create presentations, booklets, brochures, solve complex mathematical problems. Including a text editor equipped with tools with which it is easy to answer the question of how to build a graph. In Word, you can set parameters for charts of any kind. Only those who do not know how to go to the necessary tab and what data to enter during construction will not cope with such tasks.

how to build a chart in Word

Charts in Word 2007

The 2007 Microsoft text editor is very different in its interface from the 2003 software. But for those who are used to the latter, it will be quite simple to deal with the Word of the penultimate version. The fact is that all the menus and teams the developers simply put into tabs, the same are displayed in browser programs. And in Word 2007, there was no need to search for the necessary option, opening alternately one drop-down window, then another.

To answer the question of how to build graphs in Word, you also need to go to a specific tab. The developers attributed them to the total number of diagrams, but in order not to get confused, we state everything in order. For example, we solve the problem of studying the simplest function.

how to make a schedule in Word

Task example

Suppose y = 2x-3. Then, in order to plot the function, it is necessary to set some values ​​of x. Take them arbitrarily. For example, x = 1, x = 1.5, x = 2, x = 2.5. It is worth mentioning that two points are enough for a linear function, but we’ll take four, since at the moment it’s important not only to solve the problem, but to explain the principle of how to build a graph in Word. Then we solve the equation by substituting the selected values ​​of x. As a result, y will be equal to -1, 0, 1, 2 (respectively).

how to draw a graph in Word

Choice of chart type

After starting the text editor, go to the "Insert" tab. This is where the chart menu is located. After clicking on the corresponding icon, a pop-up window will be displayed on the screen. It presents various kinds of diagrams. The user needs to select a line with the name “Chart” and click the mouse in the “OK” checkbox.

Building

A template is displayed on the sheet. As a rule, it contains several curved lines and two axes. It is easy to guess that horizontal is the value of x, vertical is y. Curved lines in the solution and construction will be replaced by one, but true.

As soon as the user agrees with the selected schedule option, the program window will be divided into two parts. The Word sheet is displayed on the left, Excel on the right. The spreadsheet already contains data that determine the location of the curves specified by the program. To answer the question of how to make a graph in Word according to a given example, the user needs to change the values ​​of the series (their names are on the top line of the spreadsheet), as well as the categories. Instead, x values ​​must be entered. Two extra columns of the rows need to be removed, in the remaining values ​​enter the obtained values ​​of y. The spreadsheet will take the following form:

Row 1

1

-1

1,5

0

2

1

2,5

2

As the user changes the data, the graph image itself will change. Two extra lines will disappear, and the remaining segment will take its due form.

graphics in Word 2007

The last steps in the "Word"

The answer to the question of how to build a schedule in Word is practically received. But there is one more point. The fact is that to the right of the graph are symbols of the constructed and remote lines. They bear the name "Row 1", "Row 2", "Row 3". By clicking on the last two in the chart area, the user can easily delete them with the Delete key. The remaining symbol must be renamed in the cell of the spreadsheet, replacing the name "Row 1" with the inscription "y = 2x-3".

Final touches in Excel

After the user has deleted the extra symbols in the diagram area, he needs to eliminate the extra data in the spreadsheet. To do this, just change the data range of the graph by dragging the lower right corner of the frame to the desired values.

After that, the name y = 2x-3 will be displayed at the top of the chart. On this, the construction of the schedule in the Word can be considered completed.

Other features

The considered example is the answer to the question of how to build a graph in Word for a simple function. But what is good about this text editor is its wide functionality. Entered data can be easily applied with two mouse clicks to other types of diagrams. The user only needs to enter the same “Insert” tab and select any type of graphic display of data in the drop-down menu. A text editor will instantly change the type of chart.

Conclusion

How to draw a chart in Word? This task is not difficult at all, but is it worth it if the functionality of a text editor is so universal that it allows you to create any line with millimeter accuracy after entering data into a spreadsheet? I think the answer here is obvious.

Source: https://habr.com/ru/post/C44384/


All Articles