Статьи

How to make a chart on a table in Word?

Good day! In this article you will learn how to make a chart in the Word on the table. Most novice users face with difficulties in creating a common chart in the Vordovsky file. This is especially felt by those who have had to work in the EXCEL documents of the old good version of 2003, and with the advent of innovative office versions, it is easily difficult when working with inserting all sorts of objects.

Today we will be considered as quickly and without efforting to add a chart to the 2010 file, and then fulfill work with it. In addition, I will tell you what is a diagram, and for what it is intended.

Charts in Word - What is it?

So, diagrams are used to display all sorts of digital values ​​schematically. At the expense of such a format, it is possible to significantly simplify the understanding of the massive volume, both numerical values ​​and their relationship.

How to make a chart on a table in Word

Both in Excel files and in Word documents, it is possible to use a significant number of diagrams of a wide variety of types. Due to this, they can become the most accessible to the perception of this or that audience. For example, it is easily possible to select a view: whether it is a histogram or a circular one. In addition, it is possible to combine their combination, creating a beautiful drawing.

How to make a chart in Word on Table Word 2007 - 2013

To add a diagram, you can go one of several ways:

  1. Implement the diagram
  2. Perform the insertion chart associated with all the values ​​and text located in Excel spreadsheets.

To perform the insertion by the first method, you should click the mouse where you need to place a chart. Then, to go to the "Insert" tab and press the confirmation key. As a result, an Excel e-book will be opened:

How to make a chart on a table in Word

To enter new data is possible by clicking on the appropriate cells. Thus, the user can easily replace the name of the axis and legends. The next step is reduced to click on the Microsoft Office tab (for version 2007) or the "File" (in 2010 - 2013).

The corresponding field will have to printed the name of the file, and then click "Save". As a result, a new file containing a finished diagram will be seen on the desktop.

A moment of attention, maybe you will be useful to know how to exile to find the desired word or how to distribute WiFi from the phone to the computer.

We introduce a diagram

In Word, there is a function of implementing a diagram copied from the Excel file after inserting it into a text editor. At the same time, the data of the "related" diagram will automatically be updated in the case of adjustments to the Exelevsky list.

  • So, you should click on the border of the already built diagram to be copied, and then click on the item from the Cut toolbar menu.
  • After that, you must click on the site where it should be located in the Vordovsky file, and then click "Paste". The conservation process is carried out in the same way as in the previously discussed version.
  • If there is a need, you can create all sorts of graphic items using "Smart Art".

On this, my material about creating a diagram in Word files is over, I hope you understand how to make a chart in the Word on the table. Before a new meeting on my blog pages!

How to make a chart in the Word on the table?

5

(100%)

1

Voted

How to make a chart on a table in Word

Charts help to represent numeric data in a graphical format, a significant simplifying understanding of large amounts of information. Also, with the help of diagrams, you can show relationships between different rows of data.

Microsoft office package component, Word program, also allows you to create diagrams. About how to do it, we will tell below.

Note: Having a Microsoft Excel installed software product on a computer provides advanced features for building diagrams in Word 2003, 2007, 2010 - 2016. If the excel is not installed, Microsoft Graph is used to create diagrams. The diagram in this case will be presented with related data (table). You can not only enter your data in this table, but also to import them from a text document or insert out of other programs.

Creating a basic diagram

You can add a diagram to a Word in two ways - to introduce it into a document or insert an Excel chart that will be associated with the data on the EXEL sheet. The difference between these diagrams is where the data contained in them is stored and how they are updated immediately after the insertion in MS Word.

Note: Some charts require a specific location of the data on the MS Excel sheet.

How to insert a diagram by introducing it into the document?

The excel diagram embedded in the Word will not change even when the source file is changed. Objects that have been implemented in a document become part of the file, ceasing to be part of the source.

Taking into account the fact that all data is stored in Word document, it is especially useful to use the implementation in cases where you do not need to change these data on the source file. Also, Introduction is better to use when you do not want users to work with the document in the future, have to update all associated information.

1. Click the left mouse button in the place of the document where you want to add a chart.

How to make a chart on a table in Word

2. Go to the tab "Insert" .

How to make a chart on a table in Word

3. In the group "Illustrations" Choose "Diagram" .

How to make a chart on a table in Word

4. In the dialog box that appears, select the desired diagram and click "OK" .

How to make a chart on a table in Word

5. The sheet appears not only the chart, but also Excel, which will be in the separated window. In it, an example of data will be displayed.

How to make a chart on a table in Word

6. Replace the example of the data presented in the Excel separated window to the values ​​you need. In addition to data, you can replace the sample signatures of the axes ( Column 1. ) and the name of the legend ( Row 1. ).

7. After you enter the necessary data in the Excel window, click on the symbol. "Changing data to Microsoft Excel "And save the document: "File" "Save as" .

How to make a chart on a table in Word

8. Select a place to save the document and enter the desired name.

How to make a chart on a table in Word

9. Click "Save" . Now the document can be closed.

This is just one of the possible methods with which you can make a chart on the table in the Word.

How to add an associated Excel chart to a document?

This method allows you to create a diagram directly in Excel, in an external program of the program, and then simply insert its associated version in MS Word. The data contained in the associated diagram will be updated when you make changes / updates to the outer list in which they are stored. The Word itself stores only the location of the source file, displaying the related data shown in it.

This approach to creating diagrams is especially useful when it is necessary to include information for which you are not responsible. These may be the data collected by another person who will update them as needed.

1. Cut a chart from Excel. You can do it by pressing keys "Ctrl + X" Or using a mouse: Select a chart and click "Cut" (Group "Clipboard" Tab "Home" ).

How to make a chart on a table in Word

2. In Word, click on the place where you want to insert the chart.

How to make a chart on a table in Word

3. Insert the diagram using the keys "Ctrl + V" Or select the appropriate command on the control panel: "Paste" .

How to make a chart on a table in Word

4. Save the document together with the diagram inserted into it.

Note: The changes made by you into the Excel source document will be immediately displayed in the Word document in which you inserted a chart. To update the data when you re-open the file after it is closed, you will need to confirm the data update (button "Yes" ).

In a concrete example, we considered a circular diagram in the Word, but in this way you can make a diagram of any type, whether it is a graph with columns, as in the previous example, a histogram, bubble or any other.

Changing the layout or style diagram

You can always change the appearance of the diagram you created in Word. It is not at all necessary to manually add new elements, change them, format - there is always the possibility of applying a finished style or layout, which in the Microsoft Arsenal from Microsoft contains a lot. Each layout or style can always be changed manually and configured in accordance with the necessary or desired requirements, it is also possible to work with each individual element of the diagram.

How to apply ready-made layout?

1. Click the diagram you want to change and go to the tab "Constructor" located in the main tab "Working with diagrams" .

How to make a chart on a table in Word

2. Select the diagram layout you want to use (group "Magnets diagrams" ).

3. The layout of your diagram will change.

How to make a chart on a table in Word

How to apply ready-made style?

1. Click the diagram to which you want to apply the Ready Style and go to the tab. "Constructor" .

2. Select the style you want to use for your diagram in the group "Chart styles" .

3. Changes will immediately affect your diagram.

How to make a chart on a table in Word

In this way, you can change your diagrams what is called on the go, choosing a suitable layout and style, depending on what is required at the moment. For example, you can create multiple different templates to work, and then change from, instead of creating new ones (on how to save diagrams as a template we will tell below). For example, you have a schedule with columns or a circular chart, selecting a suitable layout, you can make a chart with percentages in Word.

How to make a chart on a table in Word

How to manually change the layouts of charts?

1. Click on the chart or separate item, whose layout you want to change. This can be done differently:

  • Click anywhere in the chart to activate the tool "Working with diagrams" .
  • In the tab "Format" , Group "Current Fragment" Click on the arrow next to "Chart elements" After which you can choose the desired item.

2. In the tab "Constructor", in a group "Magnets diagrams" Click on the first item - "Add chart item" .

3. In the unfolding menu, select what you want to add or change.

Note: The parameters of the layout selected and / or modified by you will be applied only to the dedicated diagram element. In case you have allocated the entire diagram, for example, the parameter "Data Tags" will be applied to all content. If only the data point is allocated, the changes will be applied exclusively to it.

How to change manually format elements chart?

1. Click on the diagram or its separate item whose style you want to change.

2. Go to the tab "Format" section "Working with diagrams" And do the necessary action:

  • To format a dedicated diagram element, select "Format of the selected fragment" in a group "Current Fragment" . After that, you can set the necessary formatting parameters.
  • To format the figure, which is the element of the chart, select the desired style in the group "Styles of Figures" . In addition to changing style, you can also pour the figure to color, change the color of its contour, add effects.
  • To format text, select the desired style in the group "Wordart Styles" . Here you can perform "Fill text" , "Text contour" or add special effects.

How to make a chart on a table in Word

How to save a diagram as a template?

It often happens that the diagram created by you may be needed in the future, exactly the same or its analogue, it is no longer so important. In this case, it is best to save a chart as a template - it will simplify and speed up work in the future.

To do this, just click on the chart on the right mouse button and select item. "Save as a template" .

In the window that appears, select a location for saving, set the desired file name and click "Save" .

That's all, now you know how to make any chart, embedded or related, having a different appearance, which, by the way, can always be changed and adjust to your needs or necessary requirements. We wish you productive work and efficient learning.

We are glad that you could help you solve the problem.

Ask your question in the comments, while playing the essence of the problem in detail. Our specialists will try to answer as quickly as possible.

Will this article help you?

Well no

Charts in Microsoft Word are an excellent tool for visualization and a visual representation of complexly perceived volumes of numerical information in the text. Charts allow you to clearly trace the patterns, the ratio of actual quantities, identify trends and logical sequences in data arrays. Microsof Word from Office package provides a sufficient set of tools for quickly creating diagrams of all common types.

How to make a diagram in the Word In modern versions of the text editor, Microsoft Word diagrams are created as follows.

  1. Set the cursor to the document place in which the diagram is needed.
  2. In the main menu of the program, select "Insert", in which you activate the "Diagram" tab.

    Tab "Diagram" menu "Insert"

  3. On the right side of the window that appears, select the desired type of diagram. The main types of available charts that are most commonly used depending on the goals set:
    • Graphics - The chart in the form of a graph will allow you to visually demonstrate the dynamics of changing a certain value depending on the specific indicator. Change of income per month, performance on various years - typical areas of use of graphs.
    • Circular The diagram is used to show the ratings of several quantities combined with a specific common parameter. For example, with its help, it is possible to show the shares of people of different nationalities within one state, the ratio of various sources of income in the total mass of profits.
    • bar graph - will allow to show the change in the ratio of sustainable groups of certain quantities depending on the factor. For example, the ratio of the cost of the euro to the dollar, the dollar to the ruble today, a week ago, two weeks, three and so on. This is a rather complicated type of diagrams, which is formed, based on the values ​​of five columns, in which information on the volume, the lowest course, the highest course, the closing course and the opening rate.
    • Birzh The diagram is used by brokers, for clarity changes in the growth-fall in prices for companies, or currency courses. Exchange charts allow you to track connections at once several quantities, depending on the selected indicator in the role of which the time is most often. For example, on one schedule you can present the daily dynamics in terms of sales, with the simultaneous control of the maximum and minimum sale price with the indication of the value of the tracking positions at the time of closure.
    • Surface The diagram is most often used in scientific activities to display three-dimensional models of various processes.

    Other types of diagrams are either varieties of those already discussed or used much less frequently.

    Choosing a type of diagram

  4. After selecting the diagram type, click on the "OK" button after which the diagram example will appear in your document. At the same time, the list of values ​​in Excel will open, on the basis of which this diagram is built. Your task is to edit the data on the sheet, replace the indicators to their values. After entering each new value in Excel, the Word graph will be automatically rebuilt and you only need to monitor the correctness of the input of information. After enhancing all these data, the Excel window can be closed.

    Creating data to build a chart

  5. The final stage of the creation of the diagram is the design. You can add a name to the diagram, make an accurate setting of various diagram design parameters. To do this, place the cursor in the diagram area and when it takes the form of a cross from the arrings, press the right mouse button. In the context menu that appears, select the desired item.

    Final design diagram

Competently and timely using charts in Word, you significantly increase the chances of the fact that the information you provide is definitely understood and clearly represented in comparison with tabular or textual forms of supplying the same material.

If you need to visualize the data difficult to perceive, then this may help the chart. With the help of the diagram, you can easily demonstrate the relationship between different indicators, as well as identify patterns and sequences in the available data.

You may seem that to create a diagram you need to use complex programs in the development of the program, but this is not the case. To do this, you will have a fairly conventional Word text editor. And in this article we will demonstrate it. Here you can learn how to make a chart in Word 2003, 2007, 2010, 2013 and 2016.

How to make a diagram in Word 2007, 2010, 2013 or 2016

If you are using Word 2007, 2010, 2013 or 2016, then in order to make the chart you need to go to the "Insert" tab and click there on the "Diagram" button.

After that, the "Insert Chart" window appears before you. In this window, you need to select the appearance of the diagram you want to insert into your Word document and click on the "OK" button. For example, choose a circular chart.

After you select the appearance of the chart, in your Word document, an example of how the diagram you can look like. At the same time, the Excel program window will immediately open. In Excel, you will see a small table with data that are used to build a chart in Word.

In order to change the inserted diagram to their needs, you need to make changes to the table in the Excel program. To do this, simply enter your own column names and the necessary data. If you need to increase or reduce the number of rows in the table, then this can be done by changing the area highlighted in blue.

After all the necessary data is entered in the table, the Excel program can be closed. After closing the Excel program, you will receive the chart you need in the Word.

If in the future there will be a need to change the data used to build the chart, then for this you need to highlight the diagram, go to the "Designer" tab and click on the "Change Data" button.

In order to configure the appearance of the chart, use the "Designer" tabs, the "layout" and "format" tab. Using the tools on these tabs, you can change the color of the chart, signatures, flow around the text and many other parameters.

How to make a circular diagram in Word 2003

If you are using the Word 2003 text editor, then in order to make the chart you need to open the "Insert" menu and select the "Figure - Chart" item there.

As a result, a diagram and table will appear in your Word Document.

To make a circular diagram, right-click on the chart and select the menu item "Type of Chart".

After that, a window will appear in which you can choose the appropriate type of chart. Among other things, here you can choose a circular diagram.

After saving the appearance of the appearance of the chart, you can proceed to changing data into the table. Click two times the left mouse button on the chart and the table appears before you.

Using this table, you can change the data that is used to build a chart.

Charts are capable of visually submitting complex tabular information. Decorate your text report with a beautiful schedule is easy, in Microsoft Word, good tools are presented for this. Let's tell how to make a chart in the Word - directly in a text editor or transfer from Excel, how to set it out its appearance.

Insert directly

To make a graph in the Word, you will need numeric data on the basis of which a graphic image will be built. How to Create a chart: Go to the "Insert" tab, in the "Illustration" section, select "Paste a chart". In the window that appears, select Type - Histogram, linear, petal or any other. Click "OK", the Excel template and table will appear under it with numbers for example.

We will make a circular diagram - enter your data in the plate, the schedule will automatically change. First column - signatures of categories, the second - their meanings. After entering the input, close the sign on the Cross button, the information will be saved and is available for editing at any time.

How to draw a schedule: Select the type of "graphics" when creating. The first column is the marks of the points, the rest correspond to the lines. To add an image of another line, just enter the number to the next column to make the lines - remove the last column. The number of rows is the amount of data for each category.

Import from Excel

If your data is stored in Microsoft Excel, you can build a diagram there, and then copy it to Word. Documents will contact when changing the source data in the table will automatically update the appearance of graphs.

How to insert a chart from Excel:

  • Click on the schedule in Excel, select "Cut" or press Ctrl + x. The graphic image will disappear, only data will remain.
  • Go to Word, set the cursor in the right place, click on "Paste" or Ctrl + v.
  • Save the document. The next time you open, select "Yes" to update information.

Settings

We figured out how to build a schedule, now configure its display. If you need to change the values, click on the histogram right-click, go to "Change Data". A sign available for editing will appear. Through the same context menu, you can replace the type of chart, the format of signatures and a number of values.

Tools for quick editing appearance appear on the right when clicking on the schedule with the left button. They will help add or remove individual items, apply the style, configure the display of points.

For flexible configuration of the chart in Word, there are 2 tabs: "Designer" and "Format". They appear in the menu when clicking on the created schedule. In the Designer tab, create a unique appearance using ready-made templates of express layout, style and color schemes.

You can change the details of any fragment and manually: click on the desired Graphic element, go to the "Format" tab. In the "Current Fragment" section, select the "Format of the selected fragment", the option will appear on the right. Draw your style by changing the fill, borders, shadow parameters, effects. For text, you can change the contour, fill, insert Wordart styles.

Conclusion

We told how to build diagrams in Word and how to change their appearance. Try to independently make graphs - thoughtful tools make the process of fascinating.

If an Excel application is installed on your computer, you can use the advanced features of building charts in Word.

Chart information

Charts are used to represent the number of numerical data in a graphical format that simplifies an understanding of a large amount of information and relationships between different data series.

Sheet and diagram data

1. Sheet data

2. Diagram created based on sheet data

Excel supports various types of diagrams, which allows you to submit the data most clear for a particular audience in the way. When creating a new or change of an existing diagram, you can select one of the diverse types (for example, a histogram or circular diagram) and subtypes (for example, a histogram with accumulation or a bulk circular diagram). Along with different types in one diagram, you can create a mixed diagram.

Mixed diagram

For more information about the types of diagrams supported by Excel, see the article Types of Charts.

Chart elements

The diagram consists of various elements. Some of them are displayed by default, others can be added as needed. You can change the type of diagram elements, moving them to another place or change their size or format. You can also delete diagrams that do not need to display.

Diagram and its elements

1. Diagram area.

2. Region constructing chart.

3. Data points for a number of data marked in the diagram.

4. Category axis (horizontal) and values ​​(vertical), along which a diagram is built.

5. Legend chart.

6. The names of the chart and the axes that can be used in the diagram.

7. Signature of data with which you can designate data from the data point in a number of data.

Changing the basic diagram in accordance with the needs

By creating a diagram, you can change any of its elements. For example, you can change the axis type, add the name of the chart, move or hide the legend, and add additional items.

To change the diagram, you can do the following:

  • Changing the type of axes of the diagram. You can specify the scale of the axes and change the gaps between the values ​​or categories. For the convenience of reading the chart, you can add to the fission axes and indicate the amount of the gaps between them.

  • Adding to the names and data label to the diagram To explain the data display displayed on the diagram, you can add the name of the chart, the names of the axes and the data marks.

  • Adding legends and data table You can display or hide the legend, change its location or items. In some diagrams, you can also display a data table in which the legend keys and the values ​​presented in the diagram are displayed.

  • The use of special parameters for diagrams of different types. For various types of diagrams, various special lines can be used (for example, a oscillation corridor and trend line), bands (for example, stripping and lowering bands and error limits), data markers, etc.

Application of finished styles and layout diagrams for professional design

Instead of adding or changed chart elements and format them manually, you can quickly apply to the data ready layout or diagram style. In Word, there are many useful ready-made layouts and styles that can be used as it or adapt by changing manually layout or format of individual chart elements, such as the area of ​​the chart, the area of ​​construction, data series and the legend.

When using the finished layout of the chart on it, a specified set of elements is displayed in a specific order (for example, name, legend, data table or data label). You can pick up a suitable layout of the specific type for diagrams.

When using the finished style of the diagram, its formatting is based on the applied document theme, so the appearance of the chart will correspond to the colors of the topic (set of colors), the fonts of themes (set of fonts of headers and the main text) and the effects of the topic (set of borders and fills) adopted in the organization or specified user.

You can not create your own styles or layouts, but you can create diagrams templates containing the desired layout and formatting.

Attractive diagram formatting

In addition to the use of the finished style of the diagram, you can easily change the formatting of its individual elements, such as data markers, diagram areas, the area of ​​construction, numbers and text in the names and signatures, which will attract attention and make the original chart. You can also apply the styles and Wordart styles or format shapes and text in the chart elements manually.

To add formatting, you can do the following:

  • Fill chart elements. To attract attention to certain elements of the chart, you can pour them with color, texture, pattern or gradient.

  • Changing the contours of the chart elements. To highlight the elements of the chart, you can change the color, type or thickness of the lines.

  • Adding special effects to chart items To make a chart of completeness to its elements, you can apply special effects, such as a shadow, reflection, glow, edge smoothing, relief or bulk rotation.

  • Formatting text and numbers Text and numbers in the names, signatures and inscriptions on the diagram can be formatted as well as text and numbers on the sheet. To highlight the text or number, you can even apply Wordart styles.

Reuse diagrams by creating templates

If you need to repeatedly use the configured chart, you can save it as a diagram template (CRTX file) in the chart template folder. When creating a diagram, you can apply the template in the same way as the built-in type of chart. Diagram templates are custom diagrams - with their help you can change the type of existing diagram. If you need a frequent application of a specific chart template, you can save it as the default diagram type.

Top of page

Action 1. Creating a basic chart

The diagram can be added to the Word document in one of two ways: by introducing it or by inserting an Excel chart associated with the Office Excel sheet 2007. The main differences between the embedded and related diagrams are where the data is stored and how they are updated after insertion in Word document.

Note: For some types of diagrams, it is necessary to position the data on the Excel sheet in a certain way. For more information, see Streamlining Data on Excel Sheet.

Insertion chart by introducing it to the document

If the Excel chart is embedded in the Word file, it will not change even when changing the Excel source file. Implemented objects become part of the Word file and cease to be part of the source file.

Since the data is fully stored in one Word document, the implementation is useful to use when you do not want them to change with the changes in the source file, or do not want the document recipients to update the associated information.

  1. In Word Document, select Insert > Diagram .

    Part of the 'Insert' tab with the 'diagram' button

  2. Select the type of chart (for example, a histogram or a circular diagram) and click OK . (If you do not know exactly what to choose, go through the list All charts And look at each type.)

    Dialog box 'insertion charts' with sketches of different chart options

  3. Enter the data to the spreadsheet that will automatically open with the diagram. The diagram will be updated with the data introduced into the cell when switching to the next.

  1. In Word, click in the place where you want to insert a chart.

  2. On the tab Insert in a group Illustrations Press the button Diagram .

  3. In the dialog box Insertion chart Select a diagram and click OK .

  4. Enter the data to the spreadsheet that will automatically open with the diagram. The diagram will be updated with the data introduced into the cell when switching to the next.

  1. In Word, click in the place where you want to insert a chart.

  2. On the tab Insert in a group Illustrations Press the button Diagram .

  3. In the dialog box Insertion chart Select a diagram and click OK .

    Office Excel 2007 will open in a separate window and displays an example of data on a sheet.

    Data example for chart

  4. In the Excel window, replace an example of a data by clicking the cell on the sheet and entering the required data.

    You can also replace examples of axes signatures in column A and the name of the legend in line 1.

    Note: After updating the sheet, the Word chart is automatically updated with the new data.

  5. In Excel, click Microsoft Office. An image of the Office buttonAnd select Team Save as .

  6. In the dialog box Save as in the list Save B. Select a folder or disk where you want to save a sheet.

    To save the sheet to a new folder, click create a folder Button icon .

  7. In field File name Enter the name of the new file.

  8. Press the button Save .

  9. In Excel, click Microsoft Office. An image of the Office buttonand click Close .

Top of page

Insertionless Excel Chart in Document

You can create a chart on an external list of Excel 2007, copy it and insert its associated version to Word document. If the diagram is associated, the data in it is updated when the external leaf of Excel changes. Related Data Store on Excel Sheet. The Word document consists only the location of the source file and the associated data is displayed.

Binding is also convenient to use when you need to include in the final file information that is stored separately, such as data collected by another department, or when you need to constantly update the data in Word document. For more information about creating diagrams in Excel, see Creating a diagram.

  1. In Excel, select a chart by clicking its border and then on the tab home in a group Clipboard Click Cut .

    The diagram will be deleted, but its data will remain in Excel.

  2. In Word, click in the place of the document where you want to insert a chart.

  3. On the tab home in a group Clipboard Press the button Insert .

    Button Insert parameters Indicates that the diagram will be associated with Excel data.

  4. Save the Word document with an Excel-related diagram.

    When you restart Word document, click Yes To update Excel data.

You can also create a visual presentation of data using SmartArt graphic elements. For more information, see Creating a SmartArt graphic element.

Top of page

Streamlining Data on Excel Sheet

Most diagrams, such as histograms and bar charts, can be built on the basis of data located in lines or sheet columns. However, for some types of diagrams, such as circular and bubble, it is required that the data be located in a certain way.

  1. Add data to the sheet, on the basis of which you need to build a diagram.

    Data can be positioned in the form of rows or columns - Excel will automatically determine the best way to build a diagram. For some types of diagrams, such as circular and bubble, it is required to arrange data in a certain way as described in the table below.

    Type of diagram

    Data location

    Histogram, line, schedule, with regions, surface or petal

    By columns or rows, for example:

    Or:

    Circular or ring diagram

    One column or line of data and one column or line of data labels for one data series, for example:

    Or:

    Several columns or lines of data and one column or data label string for several data series, for example:

    Or:

    Point or bubble diagram

    The data is located on columns, and the X values ​​in the first column, and the corresponding values ​​of Y and the dimensions of the bubbles in the adjacent columns, for example:

    X

    Y

    Sizes of bubbles

    1

    2

    3

    4

    5

    6

    Exchange diagram

    According to columns or rows in the following order, using titles or dates as signatures:

    Maximum, minimum and closing values

    For example:

    date

    Tall

    Low

    Closing

    01.01.2002.

    46,125

    42.

    44,063

    Or:

    date

    01.01.2002.

    Maximum

    46,125

    Minimum

    42.

    Closing

    44,063

  2. Select the cells containing the data you want to use to build a chart.

    Tip: If you select only one cell, Excel will automatically build a diagram based on the adjacent cells that contain data. If the desired cells are not included in the adjacent range, unbending cells or ranges can be isolated; In this case, the selection should be a rectangle. You can also hide rows and columns that do not need to reflect on the diagram.

    Selection of cells, ranges, rows and columns

    To highlight

    Follow these steps:

    Separate cell

    Click the cell or use the arrow keys to go to the desired cell.

    Range of cells

    Click the first range of the range, and then drag the mouse to its last cell. You can also press the SHIFT key and expand the selected area using the arrows.

    In addition, you can select the first range of the range, and then press the F8 key to extend the selected area using the arrows. To stop the extension of the selected area, press the F8 key again.

    Large range of cells

    Click the first range of the range, and then holding the SHIFT key, click the latest range of the range. To display the last cell, use scrolling.

    All cells of sheets

    Press the button Select all .

    Button Select All

    To highlight the entire sheet, you can also press the Ctrl + A keys.

    If the table contains the data by pressing the Ctrl + A keys, the current range is highlighted. Pressing the Ctrl + A keys will lead to the allocation of the entire table.

    Unbellible cells or cell ranges

    Select the first cell or range of cells, and then holding down the Ctrl key, select other cells or ranges.

    You can also choose the first cell or range of cells, and then press the SHIFT + F8 keys to include other non-measure cells or ranges. To stop the inclusion of cells and ranges, press the SHIFT + F8 keys again.

    Note: Cancel selection of individual non-negative cells or ranges without cancellation is impossible.

    Column or lines

    Click the title time or column.

    Sheet with a string heading and column heading

    1. Line title

    2. Column header

    You can also select cells in a row or column, highlighting the first string, and then pressing the Ctrl + Shift + arrow keys (right or left for strings, up or down - for columns).

    If the data line or column contains the data when you press the Ctrl + Shift + arrow keys, a string or column to the last filled cell will be highlighted. Pressing the Ctrl + Shift + arrow keys will lead to the highlight of the string or the column completely.

    Related rows or columns

    Clean the mouse over the headings of rows or columns. You can also select the first string or column, and then pressing the SHIFT key, select the last string or column.

    Sorny rows or columns

    Select the header of the line or column of the first line or the selection column, and then by pressing the CTRL key, click the column headers or rows to be added to the allocation.

    The first or last cell in the row or column

    Highlight the cell in the string or column, and then press the Ctrl + arrow keys (right or left for strings, up or down - for columns).

    The first or last cell on the sheet or in the Microsoft Office Excel table

    To highlight the first cell on the sheet or in the Excel list, press the CTRL + Home key combination.

    To highlight the latest cell containing data or formatting, on a sheet or in the Excel list, press the Ctrl + End key combination.

    Cells to the last used sheet cell (bottom right corner)

    Select the first cell, and then press the Ctrl + Shift + End keys to expand the selected area to the last used cell cell (lower right angle).

    Cells before leaf

    Select the first cell, and then press Ctrl + Shift + Home keys to expand the selected area before the sheet starts.

    More or fewer cells than available in active allocation

    Hold down the SHIFT key, click the last cell that you want to include in a new dedicated area. A rectangular range between the active cell and the cell, which was clicked.

    To cancel the selection of cells, click any cell on the sheet.

  1. On the tab Insert in a group Chart Perform one of the following actions.

    • Select the type and subtype of the diagram.

    • To view all the available types of diagrams, select the type of chart, and then select the menu item. All types of diagrams or Others to open the dialog box Insertion chart . Scroll through all the available types and subtypes of charts using the arrows and select the ones you want to use.

      Excel tape image

      When you hover the mouse pointer to the type or subtype of the chart, a pop-up hint appears with its name. For more information about supported types of diagrams, see the Types of Diagrams.

  2. By default, the diagram is added to the sheet as an embedded diagram. To put a diagram on a separate chart list, change its location by performing the steps below.

    1. Click the embedded diagram to highlight it.

      The tab opens Working with diagrams .

    2. On the tab Constructor in a group Location Press the button Moving chart .

      Excel tape image

    3. In chapter Place a chart Perform one of the following actions.

      • To add a diagram to a separate sheet, set the switch On a separate sheet .

        If you need to replace the proposed diagram name, enter a new name in the field. On a separate sheet .

      • If an embedded diagram is required on the sheet, set the switch on a leaf existing and then select a sheet in the field on a leaf existing .

  • To quickly create a diagram based on the default chart type, highlight the desired data and press the Alt + F1 keys. When you press the ALT + F1 keys, an embedded diagram is created.

  • When creating an Excel diagram determines the orientation of data series based on the number of lines and sheet columns that are included in it. After creating the diagram, you can change the method of displaying rows and columns on the chart by changing them in places.

  • If the diagram is not needed, it can be deleted. Click the chart to highlight it, and then press the Delete key.

Top of page

Action 2. Changing the layout or style chart

After creating the diagram, you can instantly change its appearance. Instead of manually add or change the chart elements or format it, you can quickly apply ready-made layout and style to the diagram. Word provides the ability to choose a set of useful layouts and styles of diagrams (or express layouts and express styles); If necessary, you can additionally configure the layout or style by changing manually layout and format of individual chart items.

Application of a ready layout diagram

  1. Click the diagram to which you want to apply a ready layout.

    The tab opens Working with diagrams with additional tabs Constructor и Format .

  2. On the tab Constructor in a group Magnets diagram Press the button Express layout and select the diagram layout you want to use.

    To view all available layouts, click Additional "Advanced Parameters" button .

Top of page

  1. Click the diagram to which you want to apply a ready layout.

    Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Constructor in a group Magnets diagram Click the diagram layout to be used.

    Excel tape image

Top of page

Application of ready-made diagram

  1. Click the diagram to which you want to apply the finished style.

    The tab opens Working with diagrams with additional tabs Constructor и Format .

  2. On the tab Constructor in a group Styles diagrams Select the style you want to use.

    Excel tape image

    To view all predetermined chart styles, click additionally "Advanced Parameters" button .

Top of page

  1. Click the diagram to which you want to apply the finished style.

    Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Constructor in a group Styles diagrams Select the style you want to use.

    Excel tape image

    Note: When decreasing the size of the Excel window, the diagrams styles become available in the collection Express styles in a group Styles diagrams .

    To view all predetermined chart styles, click additionally "Advanced Parameters" button .

Top of page

Changing the format of the elements of the diagram manually

  1. Click the diagram or its item, the style of which you want to change, or follow these steps to select the chart item from the list:

    1. Click Diagram to display Working with diagrams .

    2. On the tab Format in a group Current fragment Click the arrow next to the field Chart elements And then select the desired chart item.

      Excel tape image

  2. On the tab Format Perform one of the following actions:

    1. To format a dedicated diagram element, in a group Current fragment Press the button Format of the selected fragment And then select the desired formatting parameters.

    2. To format the figure of the dedicated diagram element, in the group Styles of figures Select the desired style or click Filling figures , Circuit figure or Effects for figures And then select the desired formatting parameters.

    3. To using Wordart format text in a dedicated chart element, in a group Styles Wordart. Select the desired style or click Pouring text , Contour of the text or Text effects And then select the desired formatting parameters.

      Note: After applying the Wordart style, WordArt format cannot be removed. If the applied Wordart style is not suitable, you can select another Wordart style or press the key Cancel on the Fast access panels To return to the former text format.

      Tip: To format the usual text in the chart items, you can select this text or right-click it, and then select the desired formatting parameters to Mini toolbar . You can also use the formatting buttons on the ribbon (tab home , Group Font ).

Top of page

Action 3. Adding or removing names and data labels

To make diagrams more clear, you can add names, such as the name of the diagram and the names of the axes. Axis names are usually available for all axes that can be displayed in the diagram, including the depth axis (data series) on the volume diagrams. Some types of diagrams (such as a petal diagram) contain axis, but cannot display their names. Types of diagrams that do not have axes (such as a circular and ring diagram), can also not display the names of the axes.

You can also bind the names of the chart and axes with the corresponding text in the sheet cells by creating a reference to these cells. Related names are automatically updated in the diagram when the corresponding text is changed on the sheet.

To quickly define a number of data in the diagram, you can add data labels to its data point. By default, the data labels are associated with the values ​​on the sheet and are updated automatically if they are changed.

Adding a diagram name

  1. Click the diagram to which you want to add a name, and click Chart elements   Button "Chart Elements" .

  2. In the list that appears Chart elements Check the box Diagram name .

  3. In text field Diagram name I appeared in the diagram, enter the desired text.

    To insert the string break, set the pointer to the location of the alleged break and press the Enter key.

  4. To format text, select it, and then select the required formatting parameters to Mini toolbar .

Top of page

  1. Click the diagram to which you want to add a name.

    Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Layout in a group Signatures Press the button Diagram name .

    Excel tape image

  3. Select Name in the center with overlapping or Above diagram .

  4. In text field Diagram name I appeared in the diagram, enter the desired text.

    To insert the string break, set the pointer to the location of the alleged break and press the Enter key.

  5. To format text, select it, and then select the necessary parameters on Mini toolbar .

    You can also use the formatting buttons on the ribbon (tab home , Group Font ). To format the entire name, right-click it, select the command in the context menu. Diagram name format And set the options you need.

Top of page

Adding axes names

  1. Click the chart to which you want to add axes names, and click Chart elements   Button "Chart Elements" .

  2. In the list that appears Chart elements Check the box Names axes .

  3. Select the names of the axes that must be added to the chart and enter the desired text.

  4. To format text, select it, and then select the required formatting parameters to Mini toolbar .

Top of page

  1. Click the diagram to which you want to add axes names.

    Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Layout in a group Signatures Press the button Names axes .

    Excel tape image

  3. Perform one of the following actions:

    • To add a name to the main horizontal axis (category axis), click Name of the main horizontal axis And then select the desired parameter.

      If the diagram has an auxiliary horizontal axis, you can also choose Name of auxiliary horizontal axis .

    • To add a name to the main vertical axis (values ​​axis), select Name of the main vertical axis And then select the desired parameter.

      If the diagram has auxiliary vertical axis, you can also choose Name of auxiliary vertical axis .

    • To add a name to the depth axis (data series axes), click Name of the depth axis And then select the desired parameter.

      Note: This parameter is only available if the selected diagram is really a surround diagram, such as a bulk histogram.

  4. In text field Axis name I appeared on the diagram, enter the desired text.

    To insert the string break, set the pointer to the desired location and press the Enter key.

  5. To format text, select it, and then select the necessary parameters on Mini toolbar .

    You can also use the Formatting buttons on the ribbon (tab home , Group Font ). To format the entire name, right-click it, select the command in the context menu. Axis name format And set the options you need.

    Notes:  

    • When switching to another type of diagram that does not support the names of the axes (for example, a circular diagram), the names of the axes cease to be displayed. The names will be displayed again if you switch back to the type of diagram that supports the names of the axes.

    • Names displayed for auxiliary axes will be lost when switching to a diagram type that does not display auxiliary axes.

Top of page

Adding data labels

  1. Click the chart to which you want to add data labels, and click Chart elements   Button "Chart Elements" .

  2. In the list that appears Chart elements Check the box Data labels .

  3. Select data labels to be added to the diagram and enter the desired text.

    Note: Depending on the type of diagram used, various data lamb parameters will be available.

For more information on how to change or move data labels, see Adding and Deleting Data Signatures in the chart.

Top of page

  1. On the diagram, do one of the following steps.

    • To add a data label to all data points from all data series, click the diagram area.

    • To add data label to all data points of a specific number of data, click it.

    • To add a data label to a separate point in a number of data, click the row containing the desired point, and then select it.

      Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Layout in a group Signatures Press the button Data signatures And then select the desired display parameter.

    Excel tape image

    Note: Depending on the type of diagram used, various data lamb parameters will be available.

For more information on how to change or move data labels, see Adding and Deleting Data Signatures in the chart.

Top of page

Action 4. Display and hiding the legend

When creating a diagram, a legend is displayed, but you can hide it or change its location.

  1. Click a diagram in which you want to display or hide the legend and click Chart elements   Button "Chart Elements" .

  2. In the list that appears Chart elements Install or uncheck the checkbox Legend .

If the diagram has a legend, you can change its individual elements. For more information, see the article Changing the elements of the chart legend.

Top of page

  1. Click the chart in which you want to display or hide the legend.

    Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Layout in a group Signatures Press the button Legend .

    Excel tape image

  3. Perform one of the following actions.

    • To hide the legend, select No .

      To quickly remove the legend or its element from the chart, select them and press the Delete key. You can also click the legend or element of the right mouse button and select the command. Delete .

    • To display a legend, select the desired display parameter.

      Note: When one of the parameters of the display of the legend moves, and the construction area automatically changes according to it. If you move the legend and change its size using the mouse, the construction area will not automatically change.

    • To set additional parameters, select Additional parameters of legends And specify the desired display parameter.

      Tip: By default, the legend and the diagram do not overlap. If the place is limited, it may be possible to reduce the diagram by removing the checkbox Show legend without overlapping chart .

If the diagram has a legend, you can change its individual elements. For more information, see the article Changing the elements of the chart legend.

Top of page

Action 5. Displays and hiding the main axes of chart or mesh lines

When creating a diagram for most types of diagrams, the main axis is displayed. You can enable and disable them if necessary. When adding axes, you can specify the level of detail on which the axis should be displayed. When creating a volume diagram, the depth axis is displayed.

In order for the data on the diagram better, you can display or hide horizontal and vertical grid lines that pass from the horizontal and vertical axes through the entire area of ​​the diagram.

  1. Click the diagram on which you want to display or hide the axis or grid lines, and press the button. Chart elements   Button "Chart Elements" .

  2. In the list that appears Chart elements Install or uncheck the checkbox Axis or Grid .

Top of page

  1. Click the diagram on which you want to display or hide the axis or the grid lines.

    Panel opens Working with diagrams with additional tabs Constructor , Layout и Format .

  2. On the tab Layout in a group Axis Press the button Axis or Grid And select the desired menu item.

Top of page

Action 6. Movement or resizing chart

The diagram can be moved to any place of the document. You can also change its size to more convenient.

Changing the size of the diagram

To resize the chart, do one of the following steps.

  • Click the diagram and drag the size of the size of the size until it accepts the desired size.

  • On the tab Format in a group The size Enter the size in the field Height of Figure и Width of Figure .

    Image of Outlook Ribbon

To change the size change settings on the tab Format in a group The size Press the button Call dialog box Image of buttons. On the tab The size You can select the parameters to resize or scale the diagram as well as its turn.

Top of page

Action 7. Saving a chart as a template

If you want to create similar diagrams based on the created diagram, you can save it as a template.

  1. Right-click the diagram you want to save as a template and select Save as template .

  2. In field File name Enter the name of the template.

Note: The diagram template contains formatting diagrams and colors that were used when it is saved. In a diagram that is created in another book based on the template, colors from the template are used, and not the color of the document applied to the book. To use the color of the document themes instead of template colors, click the chart area with the right mouse button and select the command in the context menu Remove formatting is missing in style .

Top of page

  1. Click the diagram you want to save as a template.

  2. On the tab Constructor in a group A type Press the button Save as template .

    Excel tape image

  3. In field File name Enter the name of the template.

Note: The diagram template contains formatting diagrams and colors that were used when it is saved. In a diagram that is created in another book based on the template, colors from the template are used, and not the color of the document applied to the book. To use the color of the document themes instead of template colors, click the chart area with the right mouse button and select the command in the context menu Remove formatting is missing in style .

Top of page

The Microsoft Office package allows you to perform many tasks due to a varied program set. However, some functions in them coincide. One of them is diagrams that can be done in the Word. This is a fairly useful opportunity. Below, let's tell how to create them in various ways.

In contrast to Excel, Word does not need to pre-fill in the table to create a diagram. The whole process occurs gradually. Inserting this element does not represent difficulties, if you meet the instructions. More accurately, the user will follow the tips, the faster it will turn out to make a beautiful design of the document.

Creating a standard diagram

To create a standard diagram, it suffices to follow the following instructions:

  1. Open the completed or create a new Word document.
  2. Click the left mouse button to the location where the diagram is required.
  3. In the top menu, open "Insert".
  4. In the category "Illustrations", click on the "diagram". insert
  5. In a new window, specify the type of diagram using the left menu, click OK. All charts
  6. The file will create a diagram, and the Excel window will open with a table exceeded.
  7. Set the desired parameters in the Excel table. diagram

Thus, a diagram will appear in the specified location. If you need to increase the number of sectors, it is enough to create a new string in the Excel file. To delete, select unnecessary cells by holding the left mouse button, and click "Delete".

Important!

The Word diagram is created using Excel functions, so the file of the table that appears is associated in a text document. Separately save it. For the subsequent editing of the contents of the diagram, you should change the data in Excel. To do this, you need to open a text file, call the context menu of the chart and select the appropriate item in the "Change Data" category.

Layout and style

Creating a chart in Word is a pretty simple task. Sometimes it is necessary to change the insert format. For this you do not need to do everything again. You can easily change the type of diagram:

  1. Press the diagram or highlight it.
  2. The "Designer" category will automatically open on the top panel. constructor
  3. To change the format, press "Change the type of diagram" in the right corner.
  4. The same window opens as when creating inserts. You should select the desired type of diagram and click "OK".

With this method, you can not only change the type of diagram, but also replace it with a chart or histogram using the corresponding layouts. In this case, all data will be saved.

The simplest way to change the type of circular diagram

To quickly edit the type of diagram, you should use express layouts. They are premeditated data display settings. To do this, select the diagram, click on the "express layout" on the top panel and select the desired view. Circular diagram

Style change

To change the color display of the diagram, follows:

  1. Select a chart.
  2. In automatically opened section "Designer", select the desired layout in the "chart styles" category.
  3. If necessary, edit the color scheme, click on "Change Colors" and select the desired options.

When you hover on the template, it will automatically be displayed on the selected diagram.

Adding titles and data labels

In addition to style and color palette, it is often necessary to format the diagram so that all the information is clearly understood when looking at her. This uses data labels and names. You can install them by the following instructions:

  1. Click on the diagram and then on the plus icon next to the selected image. Alternatively, you can select on the top panel "Add Chart Elements" in the "Designer" category. Add item
  2. In the window that appears, you should mark the desired items.

To edit the text of the data labels and names, you must click on "Additional Parameters". To change the contents inside the blocks that have appeared, you need to press one of them. You can also change the location of the text.

Display and hiding legends

With the help of the legend, you can also make a diagram easier for perception. This can be done as follows:

  1. Click on the diagram and then on the plus icon.
  2. In the Legend "window that appears, select the location relative to the image.

Using the right menu, you can edit text and mapping, for example, disable the overlap of the legend chart. For more detailed settings, press the chart with the right mouse button and select "Legend Format".

How to add a linked chart?

The associated diagram differs from the standard in Word, as it takes all the information from a separate Excel file. When editing information in it, the image in the text document is adjusted accordingly. Make a linked diagram is quite simple:

  1. In the prepared Excel file, create a diagram with the desired data, and then select it and copy it. To do this, you can use the Ctrl + C key combination.
  2. Open the Word file and insert a diagram into it using Ctrl + V.

Thus, a diagram from the Excel file will appear in the Word document. When changing information in the original file, they will also change in a text editor.

How to change the layouts yourself?

MS Word has several types of layouts for various formats. Any of them can be changed independently. This also applies to diagrams layouts. To do this, it is enough to click right-click on the template and select the "Change" item. In the window that appears, you can edit the layout under your own requirements.

How to save diagram template?

When creating and editing the diagram, sometimes it is worth saving it as a template to spend less time on the following projects. Make it pretty simple:

  1. Right-click near the desired diagram.
  2. From the list that appears, select "Save as a template ...".
  3. Select the save folder.
  4. Click "OK".

When creating a new diagram, you can find the saved layout in the "Templates" category.

Create a basic diagram in Word is quite simple. It can be easily edited under your own requirements. This helps the built-in layouts, as well as the ability to create your own template. With the right approach, you can quickly create a clear diagram with any data.

Hello everyone, dear readers! In touch Fedor Lykov. Today I will tell you about how to build a chart in the Word.

First, consider the definition and purpose of these graphic objects in the document, and after consider the possible ways to create them. So let's go!

How to build a diagram in the Word?

Definition, Types and Purpose

The diagram is an image or a graphic drawing that allows you to visually see the ratio of several quantities.

It is used to create reports and a more detailed view of the difference in expenditure, the company's income for the quarter, to increase or decrease profits.

High-quality and relevant use of graphs data allows you to simplify your document for perception, and also very well decorate it in a visual plan. Agree at times more pleasant to the eyes of seeing the difference with some beautiful graphics, than infinitely look at the black numbers in the text.

There are the most different types of it, each of which can be used best to display some specific data.

  1. "Exchange" based on the name is created to display the increase and decrease in the currency rate.
  2. "Circular" is great for seeing the largest source of expenses.
  3. "Line-" or "histogram" allows you to visually compare several different candidates in comparison. For example, with similar diagrams, processors or video cards and data are compared based on the results of test products.

And these are not all examples. In the program itself, I counted 17 different species from each of which there are some more varieties. In general, for every taste and color.

Let's finally move on to consider the possibility of creating charts in the Word according to the step by step by step. Let's start with the traditional 2003, and we will finish more modern 2007, 2010, 2016 and so on.

Enjoy your reading!

Creating diagrams in 2003 Word

So, create a new text document for training. In it, we are interested in the menu tab at the top of the insert program window. We click on the left mouse button along it and bring the cursor to the point of the drop-down menu "Figure" and in it already choose the "diagram".

How to build a diagram in the Word

A histogram and a window with a data table appear before us, in which you can make your values ​​and names of the items.

How to build a diagram in the Word

Carefully look at the table and the histogram to correctly enter the values ​​in each cell.

To change this standard histogram to any other type, you must click just below the graph itself as in the screenshot below and select the "Type of Chart" from the context menu.

How to build a diagram in the Word

You will open a selection window in which you simply choose the option that suits you and click "OK".

At the end of the article we will definitely consider different types and their appointment, so be sure to read the article to the end!

How to build a diagram in the Word

After entering everyone, the type of choice is simply close the table window and admire your work. To re-edit the table data, press twice the left mouse button along the obtained diagram so that its area is circled with diagonal dotted lines. After that, right-click in this area and select "Table Mode".

How to build a diagram in the Word

After that, the data plate will appear again and allow you to edit them.

To edit the column color, you must click on the one you want to change the right mouse button and select the "Data Available Format" item. You can also simply click on it with left mouse button. In the window that opens, you can configure the column in more detail.

How to build a diagram in the Word

The same applies to the background of columns. By the above written instructions, you can change its color.

Now I propose to consider creating diagrams from the already available signs with data.

Create a chart on the table in Word 2003

Often it may be necessary to graphically display already ready data signs. In this case, you can try to make an automatic diagram based on data.

To do this, we will need a table for example. I made a small 3 × 4 with a random cost calculation.

How to build a diagram in the Word

As part of the training, you can simply make exactly the same.

After that, we allocate all cells of the table by holding the left mouse button and then perform the same actions as in the past case.

How to build a diagram in the Word

We will see the created histogram that uses data from the table.

How to build a diagram in the Word

So we dismantled how to build a chart in the Word 2003 step by step for dummies. Now I propose to consider this question on modern versions of the office.

Creating diagrams on modern office publications

To add them to the modern version of the office, they will not need special professional skills.

Go to the already familiar tab of the "Insert" tab and click on the "Diagram" button.

How to build a diagram in the Word

After that, the layout selection window opens. As I mentioned at the beginning of the article, there are 17 pieces here and even in each there are some kind of varieties.

How to build a diagram in the Word

We choose the layout, choose its variety and press "OK".

The chart selected by us will appear on the sheet and the Excel table window will also open to which data will be necessary. Depending on the set layout, the standard data format in it will vary. That is, it depends on the direct type of mockup destination.

How to build a diagram in the Word

At the top of the program window, we can immediately pay attention to the settings. Here we can add an item, select an express layout, change colors, select the style, change the data from the string to the column and vice versa, select the data, change or change the format to any other if the selected you did not fit or did not like it.

After editing, simply click in any free leaf place to exit the parameter settings. To re-edit, double click on any area of ​​the chart and will fall back to the settings. To change the data, click the "Edit Data" button at the top of the window on the settings panel and in this case the table editing window will open again.

How to build a diagram in the Word

Create a chart on the table in the modern office of the office

Here should be a little retreat. I do not know for what reason, but in modern versions it does not work as in 2003. No matter how hard I tried anyway, I had to enter values ​​manually. It is better to immediately make a table by means of Excel in Word.

How to do this, I told in one of the previous articles called "12 incredible ways to create a table in the Word on all versions of the office," I recommend to get acquainted.

If you already have a ready-made Word table, then you can simply build a diagram by the previous way. Then make data or convert the current table in Excel format.

Parse

Now I will show how to build a diagram in Word 2010 according to the table step by step.

At the beginning we will create a small experiment sign for example. I made a small 3 × 4 with a random cost calculation. Actually, this is the same sign, as in the case of the old version of Word, but already in the format of the spreadsheet of Excel.

How to build a diagram in the Word

Since the Excel program itself has much more interesting features in terms of building charts, it will be even more convenient. Click the "Insert" tab and see a large number of buttons for the construction.

How to build a diagram in the Word

Here the available species are sorted by categories that are denoted by miniature icons. I prefer this situation to simply choose "Recommended Charts" so that the application itself chooses the appropriate. For our calculations, he chose several species, including a schedule and a histogram.

I stopped on the histogram, since I like it most for this kind of visual calculations. You can choose any other, read the description and see an example. After selecting, press the "OK" button.

How to build a diagram in the Word

After that, you will see the resulting result in the workspace of Excel.

How to build a diagram in the Word

In order to exit the Excel interface, press any free Word List. To return to edit twice, press the left mouse button on the table.

If there is no need to change the data obtained, then I recommend to highlight it as in the screenshot above (click in the area closer to the edge). Then copy (Ctrl-C or right-click and select "Copy"). After exit from the exhale mode and paste (Ctrl-V or right-click and select "Paste").

In this case, our histogram will be in the form of a picture and more concisely fit into the document. Take a look.

Creating a chart in Word

I recommend making these actions only in the final formatting of the finished document so that the situation does not come out that you need to correct some data, and you have no table, but just a picture. Keep in mind.

Conclusion

So, we looked at all existing ways to embody your tables in the form of a visual graph or histogram and thereby dealt with the question of how to build a chart in the Word.

I bring to your attention a small table with several species of various diagrams, their description and purpose. In order for you to be able to more accurately show the necessary comparisons in the document or prepare reports.

Diagram name Description Purpose
bar graph Creating a chart in WordThe parameters value are displayed as rectangles, the height of which displays the greater value. To compare the costs of quarters or opposite to planning future costs.
Schedule Creating a chart in WordData is depicted as points connected by lines. To build a classic system rectangular coordinate system It is advisable to use with a large amount of data in a long period of time that must be submitted to compared
Circular Creating a chart in WordValues ​​are represented as a percentage ratio and are located in a circle divided into sectors, where each sector is a specific parameter of the data table. It is convenient to use when comparing costs, as it allows you to see the largest items of expenses. Therefore, the data is presented as a percentage.
Lineless Creating a chart in WordThe parameters value are displayed in the form of rectangles, the length of which displays the greater value. Similar as a histogram. It is used to compare several values.
Cascade (Waterfall) Creating a chart in WordValues ​​are represented as rectangular columns of different color, which shows a positive or negative result. Each column is responsible for the specific category of values. Allows you to determine the overall effect, consistently representing the positive and negative values ​​of the factors. Classic diagram for factor analysis.

And on this I propose to finish. I hope that the article was informative and useful. Have questions? Milicia I ask the Comment block, where I will definitely answer your questions. Thank you for reading this publication to the end. See the next meetings in the following publications!

Sincerely, author of Blog Fedor Lykov!

In this article we will talk about how to create a diagram into a Word. We will turn on all the instructions for creating a chart and not only.

Building diagrams in Word, why and when it is necessary

How to create a diagram in the WordHello, friends! We all accustomed to writing texts in Word, because they are better perceived by readers, someone earns on their writing via the Internet. But not every word text editor Word is focused only on texts. It also creates diagrams.

What is the construction of charts in the Word? All simple! With the help of diagrams, different data are compared. In a diagram, for example, one glance can be compared what income were in 2017, in 2018 and 2019.

You can also show on the chart, for example, production growth dynamics by year, can show growth or drop earned fees. You can show with the help of the chart the dynamics and the number of sales in the trading company, or the fall in incidence in such a city.

That is, diagrams are used in all spheres of human life, they complement articles well.

Next, we will consider the question of how to create a diagram in the Word.

To the contents ↑

How to create a diagram in a Word, we use Word 2007, 2010, 2013, 2016

So, we will analyze the process of creating a diagram in Word 2007, and in other versions of this program it is created by analogy.

You open the Word 2007 text editor on your computer and click on the "Insert" section in it (Screen 1).

Building charts in Word

Then you need to click on the "Diagram" button. After that, you will open the window in which you can choose the type of diagram and at the end, press the OK button (Screen 2).

How to create a chart in the Word Step-by-step instructions

After that, a diagram in the Word will be created. In addition to the Word, you will have another window - Excel sheet. It will have numeric values ​​of the created diagram that you can change. For example, replace numbers or words.

As you can see, there is nothing complicated in the question how to create a chart in the Word. Next, close and save the window with Excel to start working on the diagram in the Word.

To the contents ↑

Types of charts in Word, where to find them

In the Word you can choose many types of charts. For example, such as:

  1. Circular.
  2. Lineless.
  3. Histogram.
  4. With regions.
  5. Exchange diagram.
  6. Surface.

There are other types of diagrams that you can find through Word menu items - "Insert" and below, "diagram" (screen 3).

how to make a diagram in the Word

It is no secret that there are other types of diagrams on the Internet that can be easily downloaded to the computer and use them in your Word document. For example, it is enough to click in the "Diagram" section, the "Management of Template" button and download a new chart template from your computer.

To the contents ↑

How to create a circular diagram in the Word

You can easily create a circular diagram in the Word. For this, we press "insert" in it, hereinafter, "diagram" (screen 4).

how to create a circular diagram

In the window that opens, select the type "Circular" diagram and press the "OK" button to appear in the document (Screen 5).

Circular diagram

You can edit it - change numeric values ​​in it or its name.

To the contents ↑

How to make a diagram in a Word, organizational chart

The organizational diagram is used to display hierarchical information or relationship relationship relationships. For example, with this layout of the chart, the layouts of the assistant, subordinate and colleagues will be available.

To create such a chart in the Word, click on its control panel section "Insert" Next, the "SmartArt" button (Screen 6).

How to make a chart

In an open window, you need to choose the type of hierarchy charts further, organizational chart. Then click "OK" to appear in Word.

You can change it at your discretion, because she inserted into a document like a ready-made pattern.

To the contents ↑

Templates and Ready Style

In the Word there is an opportunity to use ready-made patterns and chart styles to edit it. To do this, select a diagram in the computer mouse document. Then, click on the Word section "Designer" to select the appropriate pattern or style of the diagram (Screen 7).

What is a diagram

For example, templates for a diagram can be selected in the sections:

  1. Layout.
  2. Layout diagrams.

To the right of styles templates, you can click on the down arrow to view even more ready-made options.

As for the styles of the diagram, they can be applied in another way - click on the "Format" section in the Word, then choose style options (screen 8).

Templates for chart

They are divided into two categories:

  1. Styles of figures.
  2. Wordart styles, that is, text style.

Next, we will change the created diagram in the Word text editor.

To the contents ↑

How to change the chart in the Word

The diagram in the Word varies quickly enough. First you need to click on it with the left mouse button, then, right and from the menu of which to select the item - "Change Data" (Screen 9).

How to change chart

Excel table with data of this diagram opens. All you need to do is replace its values ​​and press the "ENTER" button to preserve the changes.

If you want for example, change the style or diagram template, it is enough to select them in the Word Control Panel. How to make we wrote above.

After your diagram has been created and changed, you can save it to a computer. Press the button "Save as a template" button in the upper left corner and select a place to save the file on your computer. Then click "Save" so that your diagram is successfully saved on the computer.

To the contents ↑

How to make a chart in Word according to the table, chart from Excel

In the Excel program, users can work not only with table cells, but also to create a diagram in it. Make it just, as in the Word.

Open Excel Sheet Next, click in it "Insert" (Screen 10).

how to make a diagram in the Word according to the table

The control panel will then appear in which you can select a different type of diagram:

  • bar graph;
  • schedule;
  • circular;
  • linear and with regions;
  • Other diagrams.

Press the computer mouse cursor to the diagram and click on the selected option. After that you will create it.

To the contents ↑

How to create a diagram into a Word, introducing into the document

If you need to postpone the created chart from Excel into a Word, it is just enough.

Open a document Word on your computer. Next, in the exile with a diagram, you press the keyboard with the Ctrl + A key (highlight text) further, Ctrl + C (Copy Text).

Then go to the Word document and click Ctrl + V (Paste). Thus, your table will be introduced into the Word.

To the contents ↑

Conclusion

In the article, we considered the question of how to create a diagram in the Word. We also worked with chart templates and in practice it changed. Stick this instruction to create different types of diagrams without errors in the Word text editor. After all, when working with some documents, the diagram can be useful.

Thank you for attention!

Sincerely, Ivan Kunpan.

P.S. Articles on working with Word text editor:

(How to make paragraphs in the Word, how to put an emphasis on Word, how to insert a video in the Word).

Views: 13925.

How to make a chart in the Word

Charts help to represent numeric data in a graphical format, a significant simplifying understanding of large amounts of information. With their help, you can also show relationships between different rows of data. The component of the office package from Microsoft - the Word text editor - also allows you to create charts, and then we will tell about how to do it with it.

Important: The presence of Microsoft Excel installed software on the computer provides advanced features for building diagrams in Word 2003, 2007, 2010 - 2016 and more recent versions. If the tabular processor is not installed, Microsoft Graph is used to create diagrams. The diagram in this case will be presented with related data - as a table in which you can not only enter your data, but also import them from a text document and even insert from other programs.

Creating a basic chart in the Word

Add a chart to a text editor from Microsoft can be in two ways - to introduce it into a document or insert the appropriate object from Excel (in this case it will be related to the data on the source sheet of the table processor). The main difference between these diagrams is where the data contained in them is stored and how they are updated immediately after the insertion. More All nuances will be discussed below.

Note: Some charts require a specific data location on the Microsoft Excel sheet.

Option 1: Implementing a diagram in a document

The excel diagram embedded in the Word will not change even when editing the source file. Objects that were thus added to the document become part of a text file and lose touch with the table.

Note: Since the data contained in the diagram will be stored in Word document, the use of implementation is optimal in cases where you do not need to change these data with the source file. This method is relevant and then when you do not want users to work with the document in the future, would have to update all the information associated with it.

  1. To start, click the left mouse button in the place of the document where you want to add a chart.
  2. Place to insert Charts in Word

  3. Next go to the tab "Insert" where in the instrument group "Illustrations" Click on item "Diagram" .
  4. Add chart Insert in Word

  5. In the dialog box that appears, select the diagram of the desired type and view, focusing on the partitions in the sidebar and the layouts presented in each of them. Deciding with the choice, click "OK" .
  6. Add diagram Settings in Word

  7. A diagram will appear on the sheet, and a little lower - the miniature of the Excel leaf, which will be in the separated window. It also indicates examples of the values ​​applied to the element you choose.
  8. Chart on a sheet in Word

  9. Replace the default data presented in this Excel window to the values ​​you need. In addition to these information, you can replace the sample signatures of the axes ( Column 1. ) and the name of the legend ( Row 1. ).
  10. Add Chart (Excel) in Word

  11. After you enter the necessary data in the Excel window, click on the symbol. "Changing Data in Microsoft Excel" and save the document using the menu items "File" "Save as" .
  12. Save Chart in Excel in Word

  13. Select a place to save the document and enter the desired name. Click on the button "Save" , after which the document can be closed.
  14. Saving an embedded diagram in Microsoft Word

    This is just one of the possible methods with which you can make a chart on the table in the Word.

Option 2: Related chart from Excel

This method allows you to create a diagram directly in Excel, in an external program of the program, and then simply insert it into Word its associated version. The data contained in the object of this type will be updated when making changes / additions to the external sheet in which they are stored. The same text editor will store only the location of the source file, displaying the associated data shown in it.

This approach to creating diagrams is especially useful when it is necessary to include information for which you are not responsible. For example, it can be data collected by another user, and as needed it can change them, update and / or supplement.

  1. Taking advantage of the following instruction below, create a chart to Excel and make the necessary information.

    Read more: How to make a diagram in Excel

  2. Highlight and cut the resulting object. You can do it by pressing keys "Ctrl + X" Or using the mouse and menu on the toolbar: Select a chart and click "Cut" (Group "Clipboard" Tab "Home" ).
  3. Related chart in Excel in Word

  4. In Word's document, click on the place where you want to add an object carved in the previous step.
  5. Add Chart in Word

  6. Insert the diagram using the keys "Ctrl + V" , or select the appropriate command on the control panel (button "Paste" in block options "Clipboard" ).
  7. Related chart in Word

  8. Save the document together with the diagram inserted into it.

    Note: The changes made by you into the Excel source document will be immediately displayed in the Word document in which you inserted a chart. To update the data when you re-open the file after it is closed, you will need to confirm the data update (button "Yes" ).

  9. In a concrete example, we considered a circular diagram in the Word, but in this way you can create any other, whether it is a graph with columns, as in the previous example, a histogram, bubble, etc.

Changing the layout and style diagram

The diagram you created in Word can always be edited and supplement. It is not necessary to manually add new elements, to change them, format - there is always the possibility of applying a ready-made style or layout, which in the arsenal of a text editor from Microsoft contains a lot. Each such an item can always be changed manually and configured in accordance with the necessary or desired requirements, it is also possible to work in the same way with each individual part of the diagram.

Application of a ready-made layout

  1. Click the diagram you want to change and go to the tab "Constructor" located in the main tab "Working with diagrams" .
  2. Designer in Word.

  3. Select the layout you want to use (group "Chart styles" ), after which it will be successfully changed.
  4. Changed diagram layout in Word

    Note: In order to see all the available styles, click on the button located in the lower right corner of the block with layouts - it has a form of a feature under which the triangle pointing is located.

Application of finished style

  1. Click the diagram to which you want to apply the Ready Style, and go to the tab "Constructor" .
  2. In a group "Chart styles" Choose the one you want to use for your diagram
  3. Changes will immediately affect the object you created.
  4. Styles charts in Word

    Using the above recommendations, you can change your diagrams literally "on the go", choosing a suitable layout and style depending on what is required at the moment. In this way, you can create several different templates to work, and then change them instead of creating new ones (on how to save charts as a template we will describe below). A simple example: you have a chart with columns or a circular chart - choosing a suitable layout, you can make a chart with percentages shown in the image below.

Chart with percent in Word

Manual change of layout

  1. Click on the chart or separate item, whose layout you want to change. This can be done differently:
    • Click anywhere in the chart to activate the tool "Working with diagrams" .
    • In the tab "Format" , Group "Current Fragment" Click on the arrow next to the item "Chart elements" After which you can choose the desired item.
  2. In the tab "Constructor" in a group "Magnets diagrams" Click on the first item - "Add chart item" .
  3. Add Chart Element in Word

  4. In the unfolding menu, select what you want to add or change.
  5. Add item to Word

    Note: The parameters of the layout selected and / or modified by you will be applied only to the dedicated element (part of the object). If you allocated the entire chart, for example, the parameter "Data Tags" will be applied to all content. If only the data point is allocated, the changes will be applied exclusively to it.

Manual change of elements format

  1. Click on the diagram or its separate item whose style you want to change.
  2. Format of elements in Word

  3. Go to the tab "Format" section "Working with diagrams" And do the necessary action:

      Format Chart in Word

    • To format a dedicated diagram element, select "Format of the selected fragment" in a group "Current Fragment" . After that, you can set the necessary formatting parameters.
    • The format of the selected fragment in Word

    • To format the figure, which is the element of the chart, select the desired style in the group "Styles of Figures" . In addition, you can also pour the figure, change the color of its contour, add effects.
    • Styles Figures in Word

    • To format text, select the desired style in the group "Wordart Styles" . Here you can perform "Fill text" Determine "Text contour" or add special effects.

Wordart styles in Word

Saving as a template

It often happens that the diagram you created may be needed in the future, exactly the same or its analogue, it is no longer so important. In this case, it is best to maintain the resulting object as a template, simplifying and accelerating its work in the future. For this:

  1. Click on the diagram right-click and select the item in the context menu "Save as a template" .
  2. Save diagram as a template in Word

  3. In the system that appears, the system "Explorer" Specify the location for saving and set the desired file name.
  4. Save diagram in Word

  5. Click on the button "Save" To confirm.

Conclusion

That's all, now you know how in Microsoft Word make any chart - an embedded or associated, having a different appearance, which can always be changed and adjusted to your needs or necessary requirements.

CloseWe are glad that you could help you solve the problem. CloseDescribe what you did not work.

Our specialists will try to answer as quickly as possible.

Will this article help you?

WELL NO


Добавить комментарий