This article, when considering the features of constructing a diagram, will rely on the interface of the most popular and reliable version of the office suite, namely Microsoft Office Word 2007. In newer releases of the “office”, the principle remains the same, some changes in menu items and the emergence of new features are possible. for the user.

How to make a chart in Word based on the received data?

The presence of a graphical representation of the results in any report greatly simplifies the perception of information, attracts attention, and makes key points more memorable. Obviously, a presentation will only benefit from having charts or graphs, so the ability to create them is a critical skill for a PC owner. The Microsoft office suite has succeeded significantly in this and allows you to include in a text document different types of data presentation (histograms, pie charts, volume charts, mixed charts, etc.), which can be freely combined with each other. To use all the advantages of a chart in Word 2007, we need to install Microsoft Office Excel. The first method we'll learn is called document embedding. Its peculiarity is that after implementation, the data does not change, even when changes are made to the original excel table. This is done as follows:

• in the document, click on the space intended for placing the chart;
• on the toolbar we find the “Insert” item, in it we go to the “Illustrations” group, click the “Diagram” icon;
• a dialog box will appear in which we select the required diagram and confirm the action with the “OK” button;
• a split Excel window opens with sample data;
• we replace the example with specific indicators that need to be displayed;
• when the table is brought to the final version, press the “Microsoft Office” button and select the “Save As” item;
• select the place where the table will be stored, save again;
• close Excel .

Chart in Word linked to an Excel document

If it is necessary that the data in the illustration change over time, depending on the edits in the excel file, we will make a related chart. The data is stored only in Excel, the chart in Word stores only a link to a separate table. A similar illustration is created like this:

• launch Excel, select a chart by clicking on its border;
• go to the toolbar, item “Main” -> “Cut” (the diagram will be removed from the document, but all information will remain on the clipboard);
• open Word, click on the place where the chart should be, press Ctrl + V or right-click + “Paste” item from the context menu;
• save the Word file;
• the next time you open it, click the “Yes” button from the pop-up message to update the indicators from the Excel spreadsheet.

There are many functions for changing the appearance of the diagram, almost all of them are concentrated in the "Work with diagrams" menu, which opens by a simple click on any element of our illustration. The user is also able to freely move the diagram from page to page by simply dragging and dropping the mouse. If you need to bring a lot of charts to one standard view, select the design on the "Chart Tools" panel, "Designer, Layout and Format" tab.

To create a new diagram in Word 2003, you must click " Insert”, select the item “ Drawing", and then -" Diagram».

Then something like this will appear:

By clicking on the graph right mouse button, you can change it type.

You can intuitively select the appropriate view and select " OK».

Next, a picture similar to the installed type appears.

If you double-click on the image, a label will appear that allows you to change And add data. After changing, press " Enter».

The resulting graph will display changed values.

Editing graph: double click on the graph, a "highlight area" will appear.

When you press the right mouse button, a list will appear from which you will need to select " Area Format».

Here you can easily change the fill of the selected area, the color of the frame and the font.

Here's roughly how it should turn out.

In addition, you can set Options, on which the chart will be built, to launch this option, you can also click on the right mouse button and select the desired item.

You can choose what to correct in all the tabs present.

To make the data larger and the image more noticeable, it can be stretch by pulling corners.

To make changes to legend format, you need to right-click on it and select the desired item.

Can be change color, font and layout.

Double-clicking with the right button will allow you to change the part that was clicked. The main thing to start highlight all with a double click.
Among other things, you can change row format data.

Thanks to this, interesting results can be achieved. You can also set the fill method when choosing a color from the options provided by the palette.

If you want to set color only one part or change colors on certain parts, you should select these parts by clicking on the border with the mouse. And then right-click on the area itself and select "".

You can change the color and click " OK". It is preferable to change the color and other nuances at the very beginning.

Building a chart in Word 2007, 2010

Working with Word 2007 is different from working with the previous version, but it's not difficult to adapt at all.

To create, press " Insert", choose " Illustrations", and then " Diagram».

The window that appears allows you to select the type and form.

This is what it looks like" Volume cut circular". Together with the diagram, a window of another office program, Excel, opened, where a table was already prepared.

Regarding Word 2003, the work is easier, because: it is much easier to select an area with just one click on the right mouse button. That is, significantly simplified change, removal and other manipulations with each site. For example, work with the "point format" is shown.

In the window that appears, there are many parameters that can be easily changed to suit your own needs.

You can pay special attention to the fill, experiment with "Gradient Fill" by clicking "Color", and selecting this item there.

Can be set border color.

And her styles.

Chart can drop shadow, this creates an interesting visual effect.

The "" tab is also interesting. All changes must be done with each part of the graph.

This is how easy it is to transform any chart.

legend it is not more difficult to change, for this you need to click on it and select the item that changes its format.

Each section can be changed by clicking on it with the mouse. This is what the finished work will look like if you change everything.

To change the data in the Excel window that appears, you must correctly fill in the table. If the table is already closed, you should right-click on the chart and click on the item " To change the data". Then Excel will open again.

It is possible to sign data areas, These signatures will displayed and in the legend.

How to insert a chart from Excel into Word

If Excel already has a ready-made chart, but you need it to appear in Word, it is not necessary to create it from scratch and try to make a 100% copy. You can just copy already available. The clipboard will be used, which is necessary for copying any information on the computer.

To perform this procedure, you must open desired file and sheet in Excel, select the necessary data with the mouse, select the tab " Main", find there " Clipboard", and there you need to click on " Copy". You can do the same by selecting all and clicking CTRL+C.

After that, you need to open Word, click on the place where you want to insert the chart, click " Main», « Clipboard", and then click on " Insert". This can be replaced with hotkeys CTRL+V.

Laboratory work 2.

Creating and editing diagrams in documentsWorder

Word includes the Microsoft Graph charting program, which includes almost all the features of the most versatile spreadsheet program, Microsoft Excel. With Microsoft Graph, you can create high-quality, informative charts and include them in Word documents.

Create a chart

Charts are built from data contained in a data table, which is also embedded in a Word document. The created chart is linked to the data table, so when the source data changes, the chart is automatically updated. You can create fourteen basic and twenty additional chart types. In addition, within each of the main types, you can select a specific format (subtype).

For example, a table displaying data on sales of office equipment

	Computers		Printers	Copiers

If you need to create a chart based on data from a table, then you need to set the insertion point in one of the table cells and select the command Table, Select, Table. Choose a team Insert, Drawing, Diagram. Then press OK.

If you want to create a chart based on tab-delimited data typed in a document, you need to select all of that data, including the titles that will be used as legend labels and category titles.

Editing a data table

When working with a data table, you can navigate, select cells, columns or rows, change the width, etc. When the source data changes, the chart itself also changes. To change the contents of a data table cell, select the cell and enter new data. After pressing the Enter key or moving to another table cell, all existing data in this cell is replaced by the entered data.

To edit cell content, you need to select it, and then press the F2 key (switch to edit mode) or double-click on it. Changing the contents of a cell is no different from editing plain text. After the necessary corrections are made, you need to press the Enter key.

You can also expand or narrow the data set The on which the chart is drawn by adding or removing rows and columns from the data table. In this case, the diagram is automatically rebuilt taking into account the changes made to the data table.

To insert rows or columns into a table, select the required number of rows or columns and select the command Insert, Cells. To delete rows or columns from a table, you need to select them, and then select the command Edit, Delete.

Chart type

The right choice of chart type allows you to present the data in the most advantageous way. A chart type can be applied not only to the whole chart, but also to a single data series on it or to several series. Combining different chart types allows you to separate data of different types or highlight a data series, for example, you can combine a graph with a histogram.

The easiest way to change the type of the entire chart or just one data series is to use the command Chart, Chart type. In the window that appears, you can select not only the type, but also the format of the selected chart type.

To change the chart type:

1. You need to choose a team Chart, Chart type. A dialog box will appear Chart type

2. Expand the tab in this dialog Standard to select one of the main chart types or tab non-standard to select one of the additional chart types.

3. Listed Type select the required chart type.

4. If the tab is selected Standard, then in the gallery of formats View you need to select a chart subtype.

5. At the end, you must press the button OK to close the dialog box and apply the selected chart format.

To customize an existing chart type:

1. You need to choose a team Diagram. Chart options. A dialog box will appear Chart options, the parameters of which can be changed in dependencies on the chart type.

2. Use the tabs in this dialog box to customize chart elements such as titles, axes, gridlines, data labels, and so on.

3. After making the necessary changes, click the button OK.

Building stacked charts

Composite charts are charts built using two or more types of charts at the same time. In these charts, some data series are represented using one type of chart and others are represented using another. For example, you can plot one series as a histogram and the second as a graph, which makes it easier to compare data series and find their possible connections.

The created chart can be made composite, change the type used to build one or more data series. For this:

1. Select the data series in the chart, the type must be changed, and select the command Chart, Chart Type

2. In a group Options dialog box that appears Chart type check the box Apply

3. Highlight the chart type for the selected data series and click OK.

Chart elements include markers, legends, axes, labels, labels, and so on. They can make a chart more effective and informative.

The created chart can also be formatted as needed if you select the appropriate color scheme, font, focus on important elements, and remove unnecessary details.

Formatting of any diagram object is carried out using the dialog box Format. To open this window:

1. Select the required diagram object by clicking on it.

2. Choose a team Format, Selected Object, or simply double-click on the object.

The tabs of the dialog box that appears contain many formatting options with which you can customize the display of the selected Formatting element of any chart object.

BUILDING DIAGRAM

Create a document called surname_group_lab 2 .doc ., in which it is necessary to perform tasks 1-8.

Exercise 1 . Construction of diagrams.

Progress: Call the program Microsoft Graph using the command Insert/ Object/ Microsoft Graph or Insert/ Drawing/ Diagram. If the clipboard did not contain a table, then the program inserts a demo example, the data of this example can be replaced with other original data. Familiarize yourself with the commands of the main menu of the program Microsoft Graph.

Task 2. According to the table “Information on the income and expenses of the Ritm company”, construct a diagram reflecting the dynamics of the income and expenses of the Ritm company.

Intelligence

on the income and expenses of the Ritm company for January-March 1997

	January	February	March	Sum
Volume of sales
Purchase costs
Shipping costs
Income

To do this, copy the necessary rows of the source table with row and column headers to the clipboard and call the command Insert/ Figure/ Diagram.

Task 3. Construct a three-dimensional pie chart to display the company's income and expenses for the month of March (the "March" column) as a percentage.

March

Task 4. Build a flat pie chart to display the firm's first quarter earnings (the "Revenue" row) in value terms.

Task 5. Plot various types of charts (bar charts of various types, bar charts, graphs, radar charts, donut charts) according to the computer procurement table

	Computers		Printers	Copiers

Task 6 . Plot a 3D chart of computer and printer purchases in 2004 and 2005. For 3-D charts, explore changing the chart view.

Task 7. Learn how to edit chart parameters (legends, chart titles, highlighting chart segments, entering segment names, changing the color of segments and other elements).

Construct a pie chart showing computer equipment purchases in 2002. The computers sector must be painted in red, printers in blue, modems in green, copiers in brown. On the sectors, enter the value as a percentage.

Task 8. Using the menu command Insert/Name number the constructed diagrams, as follows: Diagram 1., Diagram 2., etc. Learn to edit titles.

Microsoft Office has a huge number of templates and tools for working with graphics. With their help, you can prepare a beautiful presentation or supplement the document with a visual application. To do this, figure out how to make a chart in Word. It makes it easier to present information. If you display numbers and characteristics as text, they will be scrolled through. To understand the essence of what is written, you will have to strain, carefully read and compare the data. But a properly designed schedule will immediately be remembered.

In this article, you will learn how to format charts in Word correctly.

Creating charts

Finding the necessary add dialog is quite simple

This graphic can be inserted directly into a Word document. The data must be entered in an Excel spreadsheet. It is not necessary to disassemble all the functions of this program in order to prepare a presentation. Everything is simple and clear. So, how to make a graph in Word:

1. Open a blank document.
2. Go to the menu Insert - Illustrations (or Insert - Picture). There are all the tools for working with presentations and documents: images, WordArt shapes, multimedia. Find "Create Chart".
3. Select a visualization type. On the left are the categories: pie, dot, stock, petal, line, bubble, and so on. And on the right is how the figures look. Click "OK" to build the graph.
4. This will open an Excel window. The characteristics of the object are shown in the table. The values ​​in the cells correspond to the indicators in the illustration. They represent the chart as text. When you type a character in Excel, it will immediately be reflected in Word. All names are set by default - rename them in the table. For example, instead of the word "Category", write "Indicators for the current year", and instead of "Row" - the name of the department. And change the numbers to the ones you need. So you can make a visual graph.
5. If you do not have enough characteristics, do not insert a new illustration. It's the same . The block with numbers, categories and rows in the table is framed. Drag it from the lower right corner - this will expand the diagram. Enter the desired values ​​in the empty cells.

When inserting an object in a text editor, a table is loaded

You don't need to re-create a presentation to change an existing presentation. It's better to do the following:

1. Click on an object.
2. New items appear in the menu bar. This is a toolkit with which you can customize the chart.
3. Open the Design panel.
4. To select a different illustration and still keep all the values ​​in it, click the Change Type button. It is located on the left side of the panel. So you can build a new chart, leaving the numbers and names from the old one in it.
5. If you want to enter other numbers, then click "Change data". An Excel spreadsheet will open with categories and rows. They cannot be retyped directly into Word.

Basic tools for structural adjustment on the ribbon

In the "Layout" tab, you can set a name, make a signature, add a WordArt shape, choose exactly where the categories and rows will be located. The "Format" section is intended for editing the color palette, style, markup and position in the text.

The next tab expands your options even more

Appearance of charts

Microsoft Office has many illustration templates. But if none of them suits you, then you can read how to create a chart in Word and change its appearance.

Double click on the graphic object - a settings window with several sections will appear. In Word 2007, it is called through the context menu, the "Format" item. Each element can be edited separately. Just select the part of the object you want to work on.

Learn more about menu tabs:

• Series parameters (or axis parameters). Here you can change the shape of the shapes and their location relative to each other.
• Fill. Choice of illustration color. If you want to make a chart with your own pictures, then put a marker next to the “Figure” item and click “Insert from file”. You can set textures, a gradient, a combination of different shades, and so on.
• Border styles. Frame view, fill and width settings. To work with this menu, in the "Border Color" tab, select the line type "Solid" or "Gradient".
• 3D shape format. You can make the drawing three-dimensional and choose the type of surface it will look like. But this does not work with all elements in Word. It is not superimposed, for example, on such as "Bubble" objects - they are already voluminous.

In the "Glow" and "Shadow" tabs, the corresponding effects are configured. Experiment and try different settings. Changes will be immediately reflected in the document. To move text information about rows and categories, click the Legend button on the Layout menu.

Beautiful design of the presentation makes its perception more effective.

But you can figure out how to build a chart in Word and change its appearance without looking for numerous functions. These shapes are similar to shapes from WordArt. Their individual elements are moved and stretched with the mouse. And the fill and style are in the "Format" menu. It appears at the top of the window when you select a graph.

This panel has text wrapping options. You can insert text into a drawing from WordArt and add various effects. To create a unique and memorable diagram, you do not need to use all the Word tools at once on a small piece of illustration.

Highlight an important fragment, giving it volume. Properly arrange the shadows - so there will be a feeling that the rows are at different levels. You can make the glow of the element to which you want to draw attention.

If you want to show superiors how much sales have grown, demonstrate to investors the benefits of a project, or discuss a work plan with colleagues, you need to create a beautiful and attractive diagram. Graphic objects are not only used for presentations. They are inserted into abstracts, diplomas, various documents to visualize data. Information is easier to perceive when it is shown visually. Therefore, it is useful to know how to plot a graph in Word.

MS Word has many useful features that take this program far beyond the average text editor. One of these “usefulnesses” is the creation of charts, which you can learn more about in our article. This time we will analyze in detail how to build a histogram in Word.

bar chart is a convenient and visual method of presenting tabular data in a graphical form. It consists of a certain number of rectangles proportional to the area, the height of which is an indicator of the values.

To create a histogram, follow these steps:

1. Open a Word document in which you want to build a histogram and go to the tab "Insert".

2. In a group “Illustrations” click on the button "Insert Chart".

3. In the window that appears in front of you, select the item “Histogram”.

4. In the top row, where black and white samples are presented, select the appropriate histogram type and click "OK".

5. The histogram along with a small Excel spreadsheet will be added to the document.

6. All you have to do is fill in the categories and rows in the table, give them a name, and enter a name for your bar chart.

Change histogram

To change the size of the histogram, click on it and then drag one of the handles located along its outline.

By clicking on the histogram, you activate the main section “Working with charts”, which has two tabs "Constructor" And "Format".

Here you can completely change the appearance of the histogram, its style, color, add or remove components.

Advice: If you want to change both the color of the elements and the style of the bar chart itself, first select the appropriate colors and then change the style.

In the tab "Format" you can set the exact size of the bar chart by specifying its height and width, add various shapes, and also change the background of the field in which it is located.

This is where we will end, in this short article we told you about how to make a histogram in Word, as well as how you can change and transform it.