Drawing graphs from data. How to make a graph: step-by-step instructions, tips and tricks. About charts

You can create a chart in Word. If you have a lot of data to chart, then . This is also the most The best way if the data changes regularly and you want the chart to always reflect latest values. In this case, when you copy the diagram, do not close it so that it remains linked to the original Excel file.

To create a simple chart from scratch in Word, on the tab Insert click the button Diagram, and then select the chart you want.

You can create a chart in Word or Excel. If you have a lot of data to chart, create your chart in Excel and then copy it from Excel to another Office program. This is also the best method if your data changes regularly and you want the chart to always reflect the latest values. In this case, when you copy the chart, keep it open so that it remains linked to the original Excel file.

To create a simple chart from scratch in Word, on the Insert tab, click Chart, and then select the chart you want.

IN Microsoft Word 2010 offers a variety of charts, such as pie, bar, scatter, stock, surface, donut, bubble and radar charts, area charts, histograms and graphs.

Notes:

Instructions

The graph of a function is visual representation behavior of some function on the coordinate plane. Graphs help you understand various aspects of a function that cannot be determined from the function itself. You can build graphs of many functions, and each of them will be given a certain formula. The graph of any function is built using a specific algorithm (if you have forgotten the exact process of graphing a specific function).

Steps

Graphing a Linear Function

Determine whether the function is linear. The linear function is given by a formula of the form F (x) = k x + b (\displaystyle F(x)=kx+b) or y = k x + b (\displaystyle y=kx+b)(for example, ), and its graph is a straight line. Thus, the formula includes one variable and one constant (constant) without any exponents, root signs, or the like. If a function of a similar type is given, it is quite simple to plot a graph of such a function. Here are other examples of linear functions:

Use a constant to mark a point on the Y axis. The constant (b) is the “y” coordinate of the point where the graph intersects the Y axis. That is, it is a point whose “x” coordinate is equal to 0. Thus, if x = 0 is substituted into the formula, then y = b (constant). In our example y = 2 x + 5 (\displaystyle y=2x+5) the constant is equal to 5, that is, the point of intersection with the Y axis has coordinates (0.5). Plot this point on the coordinate plane.

Find the slope of the line. It is equal to the multiplier of the variable. In our example y = 2 x + 5 (\displaystyle y=2x+5) with the variable “x” there is a factor of 2; thus, the slope coefficient is equal to 2. The slope coefficient determines the angle of inclination of the straight line to the X axis, that is, the greater the slope coefficient, the faster the function increases or decreases.

Write the slope as a fraction. The angular coefficient is equal to the tangent of the angle of inclination, that is, the ratio of the vertical distance (between two points on a straight line) to the horizontal distance (between the same points). In our example, the slope is 2, so we can state that the vertical distance is 2 and the horizontal distance is 1. Write this as a fraction: 2 1 (\displaystyle (\frac (2)(1))).

• If the slope is negative, the function is decreasing.

1. From the point where the straight line intersects the Y axis, plot a second point using vertical and horizontal distances. Schedule linear function can be constructed from two points. In our example, the intersection point with the Y axis has coordinates (0.5); From this point, move 2 spaces up and then 1 space to the right. Mark a point; it will have coordinates (1,7). Now you can draw a straight line.

   Using a ruler, draw a straight line through two points. To avoid mistakes, find the third point, but in most cases the graph can be plotted using two points. Thus, you have plotted a linear function.

Graphing a Complex Function

Find the zeros of the function. The zeros of a function are the values ​​of the x variable where y = 0, that is, these are the points where the graph intersects the X-axis. Keep in mind that not all functions have zeros, but they are the first step in the process of graphing any function. To find the zeros of a function, equate it to zero. For example:

Find and mark the horizontal asymptotes. An asymptote is a line that the graph of a function approaches but never intersects (that is, in this region the function is not defined, for example, when dividing by 0). Mark the asymptote with a dotted line. If the variable "x" is in the denominator of a fraction (for example, y = 1 4 − x 2 (\displaystyle y=(\frac (1)(4-x^(2))))), set the denominator to zero and find “x”. In the obtained values ​​of the variable “x” the function is not defined (in our example, draw dotted lines through x = 2 and x = -2), because you cannot divide by 0. But asymptotes exist not only in cases where the function contains a fractional expression. Therefore, it is recommended to use common sense:

1. Find the coordinates of several points and plot them on the coordinate plane. Simply select several x values ​​and plug them into the function to find the corresponding y values. Then plot the points on the coordinate plane. How more complex function, those more points need to be found and applied. In most cases, substitute x = -1; x = 0; x = 1, but if the function is complex, find three points on each side of the origin.

   • In case of function y = 5 x 2 + 6 (\displaystyle y=5x^(2)+6) plug in the following x values: -1, 0, 1, -2, 2, -10, 10. You will get a sufficient number of points.
   • Choose your x values ​​wisely. In our example, it is easy to understand that the negative sign does not matter: the value of “y” at x = 10 and at x = -10 will be the same.
3. If you don't know what to do, start by plugging different x values ​​into the function to find the y values ​​(and therefore the coordinates of the points). Theoretically, a graph of a function can be constructed using only this method (if, of course, one substitutes an infinite variety of “x” values).

Graph in Word will help visually show numerical data.Let's look at three options herehow to make a graph in Word.
First option.
How to make a graph in Word.
Place the cursor in the place on the page where we will install the chart. In the “Illustrations” section, click on the “Diagram” function. In the window that appears, select the “Graph” section and select the type of graph.
In the “Templates” section of the window there will be templates for our graphs, which we will save as a template.Click "OK". We have opened in a new window Excel workbook with approximate data, because the graph is based on data from an Excel table.
And a graph appeared on the Word page.

Now we need to enter our data into this Excel spreadsheet and a graph in Word will be automatically built based on this data. To add rows, columns in an Excel table for a graph, you need to drag the lower right corner of the Excel table. This method inserts the chart, but does not update it if the data in the table changes. We use it when there is no need for the data to change.

After the graph was drawn, new bookmarks appeared in Word - “Working with diagrams”.
Tab "Constructor" Chart Tools tabs- in the “Type” section you can change the type of graph and save the graph as a template for future work.
In the “Data” section, you can swap rows and columns in the graph and change the data.
In the “Chart Layouts” section, you can change the type of chart, for example, to a chart with a name, with additional lines, data areas.
In the Chart Styles section, you can choose appearance graphics – color, bold lines, etc.
“Layout” tab.
Section “Current fragment” - here you can configure any part of the chart by selecting it from the list. For example, let’s choose “Legend”. This area is highlighted with a frame on the chart.

Function “Format selected fragment” - you can click on any fragment of the graph, click on this function and a dialog box will appear. A lot can be changed here.
Here the entire graph area, chart area is selected, and the dialog box is called “Format Chart Area”.If we select the area of ​​the graph itself (colored lines of the graph), then the dialog box will be called “Format plot area”. In general, you can select any part of the chart and customize it.
“Insert” button - you can insert a drawing, figure, or inscription into the chart.
Section “Signatures” - you can remove or move different signatures in the chart field - title, data, etc.
“Data Table” button - you can place a data table (not Excel).
Tab "Format" - here you can select the style of the figure, any section of the graph, the color and font of the inscriptions, change the size of the graph, diagram, adjust the position of the graph on the page, for example, so that the text wraps around the graph or not, etc. How to work with inserted images, read the article "How to insert a photo, drawing into a Word document."Here we added data to an Excel table and made many changes to the graph.

If we don’t like the changes we made, then click the “Restore style formatting” function on the “Layout” and “Format” tabs and the graph will take its previous form.
Second option.

Insert Excel graph in Word.
Let's make a graph in Excel and then transfer it to Word. With this method, the chart will change if we change the data in the Excel table.

Opening Excel sheet, make a graph, then select it, cut it out, and paste it into Word. And the table with the data itself remains in Excel. The rest is the same as in the first option. "How to make a graph in Excel" will help you make a chart, graph, histogram in Excel.
Third option.
Insert Excel table into Word.

In the section on the question Good day! Tell me how to make labels for coordinate axes and a title for a graph in Excel??? see. inside given by the author Simply the best answer is Good afternoon.
A graph in Excel is nothing more than a diagram. If you have data, you can build a graph from it, like in your picture, you need exact numbers, displaying the number of fires in the Baikal Nature Reserve and the number of fires. We will build a table and a diagram based on it.
When creating charts, you usually use the Chart Wizard. Allows you to set the characteristics of the axes, the title of the chart and titles for its axes, the legend, labels of values ​​in data series, etc. All this can be done when creating the chart, or after it is built. -
You need to find this window, as in the picture, insert it into empty fields Labels of the abscissa and ordinate axes.
You need to open the diagram in edit mode and edit it in diagram edit mode. To do this, double-click the mouse button on the diagram, or use the context menu.
You need to change the elements of the diagram.
More details here:
3. Excel Chart Elements
An Excel chart typically consists of the following elements:
1. Category axis - one of the main elements that form the coordinate space of a diagram is the category axis, which shows the categories of the diagram. This is the X-axis, the horizontal axis of the chart, whose labels are category names.
2. The category name is, in fact, the category axis label. Category names are a very important element of the chart, on which the entire presentation of the data in the chart actually depends.
They must be entered and agreed ok.
Click the mouse on the diagram, it can be edited. On the Row tab, enter the cursor into the Labels window along the X axis and highlight the argument values ​​​​in your table (without the X label):
Please give me your chart, I’ll try to figure it out, I haven’t made charts in Excel for a long time. Give me the numbers, I’ll build a table based on them and enter the names of the abscissa and ordinate axes, and I’ll tell you in detail how I did it.
Send me a private message, I’ll help you.
Good luck)

Quite often you have to insert various graphs or diagrams into your work. You can, of course, first prepare a graph in Excel (which is included in the software package Microsoft Office), then copy it from there and paste it into the document. That's what I usually do. Or you can do it all at once in Word.

Step 1.

To build a graph (diagram), you must first have data prepared. Let's say I need to show with the help of a graph how the amount of precipitation changed over the six months. I prepare myself a sign something like this:

Step 2.

Place the cursor at the place on the page where you want to insert the graph.

Step 3.

Go to the tab "Insert" and find the command block on it "Illustrations"

Find the button in this block "Diagram" and left click on it

Step 4.

You will see a window

Select the type of graph or chart you need in this window. You can left-click on the list on the left side of the window

Or you can just drag the slider on the right side

I need graphs. In this section, I select the first sample - left-click on it

Then I press the button "OK"

Step 5.

After this, the screen will appear two windows. One - Word programs – with a graph of the sample you have chosen inserted onto the page:

Second - Excel programs– with a data table for editing.

Step 6.

Now you need to replace the sample data in Excel window their own. Instead of words "Category 1, Category 2..." I'll write it down month names from your table.

You can do it like this. Click on the cell with the words "Category 1"

I'm typing a word on the keyboard "January". I press Enter. The black frame goes to the cell with the words "Category 2".

I'm dialing "February". I press a key Enter. And I do this until I have typed all the necessary names.

And it can be made even simpler. I need the names of the months, and this is a certain pattern that the program can fill in itself. I'm typing a word on the keyboard "January" and DO NOT PRESS the key Enter. I move the cursor to lower right corner cells.

Please note that the cursor has turned into a small black cross. Clamp left button mouse and drag the pointer down the column. Small hints will appear to the right of the mouse pointer indicating which month will be entered in the cell. As soon as the last month I need appears on the tooltip - "June"- the mouse button can be released. The column will be filled.

In a column "Row 1" I am writing my details. Click on the cell with the number opposite "January" left mouse button. A black frame will appear around this cell

I type my number on the keyboard. I press a key Enter. The black frame goes to the next cell in the column. I dial my number again. And I do this until I have collected all the necessary data.

Now the Excel program window can be close. The Word program window will once again expand to full screen.

Step 7

What did I get? The names and numbers are mine. Line of blue color rebuilt based on these data. And here are the lines "Row 2" And "Row 3" extra. They need to be removed.

Move the cursor to the line "Row 2" on the chart itself and click on it with the left mouse button. The line will look like this:

Del. The line will be removed both from the graph itself and from the list on the right. Do the same with the line "Row 3". Here is the result:

Instead of words "Row 1" I'll write down the name of my chart. Click on "Row 1" left mouse button. This entry will be highlighted with markers.

Enter your name.

If the name is not needed, then after highlighting you can press the key Del and the entry will be deleted.

An entry to the right of the graph is not needed. There is only one line on the graph. Highlight this entry - left click on it

Press a key on your keyboard Del. The entry will be deleted. The schedule is ready.