• How to make a graph in Word. How to graph a function in Word

    How to build a graph in Word? What students don’t have to do when writing a coursework or dissertation. It’s good when all the design of your work can be done in the Word text editor. No need to worry about inserting graphs or pictures. But they still need to be translated into a suitable format. Sometimes you have such a hard time searching special programs, inserting files, and printing, that all studying is already beginning to seem like a living hell. How to build a graph in Word? That's the problem today. But it turns out that there are very good and free programs to ease our lot. Here is one of them - Chart Builder 1.50. With its help, graphs are built directly in the Word editor. Can be drawn with given dimensions triangle, circle or quadrilateral, and display the values specified function in the table.

    How to build a graph in word

    The program is designed for constructing function graphs, drawings geometric objects and very easy to understand. The program itself is a so-called macro. For it to work successfully, it is required that the ability to run this very macro is allowed. For this it is necessary to Microsoft Word enter the menu Service – Macro – Security

    and select medium or low level security.

    After installing the program, a new button will appear on the Word toolbar.

    If during installation you had open text editor Word, then you need to close it and open it again.

    If the button does not appear on your panel, then enter the menu ViewToolbar and select GraphBuilder .

    If you have installed on your computer Excel application, you can take advantage of Word's advanced charting capabilities.

    In this article

    About charts

    Charts are used to represent series of numerical data in graphic format, which makes it easier to understand large amounts of information and relationships between different data series.

    1. Sheet data

    2. Chart created from worksheet data

    Excel supports different types of charts, which allows you to present data in the most understandable way for a particular audience. When you create a new chart or edit an existing one, you can choose from a variety of chart types (for example, bar chart or pie chart) and subtypes (for example, stacked bar chart or 3-D pie chart). Combined in one diagram different types, you can create a mixed chart.

    Example mixed chart, which combines a histogram and a graph.

    More information For chart types supported in Excel, see Chart types.

    Chart elements

    A diagram consists of various elements. Some of them are displayed by default, others can be added as needed. You can change the appearance of chart elements by moving them to a different location or changing their size or format. You can also remove chart elements that you don't want to display.

    1. chart area.

    2. diagram plotting area.

    3. Data points for a series of data marked on a chart.

    5. Chart legend.

    6. Names of the chart and axes that can be used in the chart.

    7. data label, which can be used to indicate the information of a data point in a data series.

    Modify the base chart to suit your needs

    Once you've created a chart, you can change any of its elements. For example, you can change the appearance of the axes, add a chart title, move or hide the legend, and add additional elements.

    To change the chart you can do the following:

      Change the appearance of the chart axes. You can specify the scale of the axes and change the spacing between values ​​or categories. To make the chart easier to read, you can add tick marks on the axes and specify the amount of space between them.

      Adding titles and data labels to a chart You can add a chart title, axis titles, and data labels to help explain the data displayed in a chart.

      Adding a legend and data table. You can show or hide the legend, change its location or elements. For some charts, you can also display a data table that contains the legend keys and values ​​represented in the chart.

      Apply special parameters for different types of charts. For various types charts, you can use a variety of special lines (for example, swing corridor and trend lines), bars (for example, up and down bars and error bars), data markers, etc.

    Use ready-made chart styles and layouts for a professional look

    Instead of adding or changing chart elements and formatting them manually, you can quickly apply finished layout or chart style. Word has many useful pre-designed layouts and styles that you can use as is or customize by manually changing the layout or format of individual chart elements, such as the chart area, plot area, data series, and legend.

    When you use a preset chart layout, the chart displays a specified set of elements (for example, titles, legend, data table, or data labels) in a specific order. You can select a suitable layout from those provided for a specific chart type.

    When using a preset chart style, its formatting is based on the applied document theme, so appearance The chart will match the theme colors (a set of colors), theme fonts (a set of heading and body text fonts), and theme effects (a set of borders and fills) adopted by the organization or specified by the user.

    You can't create your own chart styles or layouts, but you can create chart templates that contain the layout and formatting you want.

    Attractive chart formatting

    In addition to using a preset chart style, you can easily change the formatting of individual chart elements, such as data markers, chart area, plot area, numbers, and text in titles and captions, which will attract attention and make the chart stand out. You can also apply shape styles and WordArt styles, or manually format shapes and text in chart elements.

    To add formatting you can do the following:

      Filling diagram elements. To draw attention to certain elements charts, you can fill them with color, texture, pattern or gradient.

      Change the outlines of chart elements. To highlight chart elements, you can change the color, type, or thickness of the lines.

      Adding special effects to chart elements To complete your diagram, you can apply special effects to its elements, such as shadow, reflection, glow, smooth edges, embossing, or volumetric rotation.

      Formatting text and numbers Text and numbers in chart titles, labels, and legends can be formatted in the same way as text and numbers on a worksheet. You can even apply WordArt styles to highlight text or numbers.

    Reusing diagrams by creating templates

    If you want to reuse a customized chart, you can save it as a chart template (CRTX file) in the Chart Templates folder. When you create a chart, you can apply a template in the same way as a built-in chart type. Chart templates are custom types diagrams - with their help you can change the type of an existing diagram. If you need to use a particular chart template frequently, you can save it as the default chart type.

    Step 1: Create a Basic Chart

    The diagram can be added to Word document in one of two ways: by embedding it or by inserting an Excel chart linked to the data in the worksheet Office Excel 2007. The main differences between embedded and linked charts are where the data is stored and how it is updated once it is inserted into a Word document.

    Note: Some types of charts require data to be arranged in a specific way. Excel sheet. For more information, see .

    Inserting a diagram by embedding it in a document

    If an Excel chart is embedded in a Word file, it will not change even if you change source file Excel. Embedded objects become part of Word file and cease to be part of the original file.

    Because the data is stored entirely in a single Word document, embedding is useful when you don't want it to change based on changes to the source file, or you don't want recipients of the document to have to update related information.

    Insert a linked Excel chart into a document

    You can create a chart in an external Excel 2007 worksheet, copy it, and paste a linked version into a Word document. If a chart is linked, the data in it is updated when the external Excel worksheet changes. The associated data is stored in an Excel sheet. A Word document stores only the location of the source file and displays a view of the associated data.

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

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

      In Word, click where you want to insert the chart in the document.

      On the tab Home in the group Clipboard click the button Insert.

      Button Paste Options indicates that the chart will be linked to Excel data.

      Save the Word document with the chart linked to the Excel data.

      When you reopen the Word document, click Yes to update Excel data.

    You can also create visual representations of your data using SmartArt graphics. For more information, see Create a SmartArt graphic.

    Organize data in an Excel worksheet

    Most charts, such as histograms and bar charts, can be drawn from data arranged in the rows or columns of a worksheet. However, some types of charts, such as pie and bubble charts, require the data to be arranged in a specific way.

      Add the data to the worksheet that you want to use to create a chart.

      Data can be arranged in rows or columns - Excel will automatically determine best way constructing a diagram. Some chart types, such as pie and bubble charts, require data to be arranged in a specific way, as described in the table below.

      Stock chart

      By column or row in the following order, using titles or dates as labels:

      high, low and closing values

      For example:

      Maximum

      Closing

      Maximum

      Closing

    1. Select the cells containing the data you want to use to create the chart.

      Advice: If you select only one cell, Excel automatically builds a chart based on the adjacent cells that contain data. If the cells you want are not in a contiguous range, you can select nonadjacent cells or ranges; in this case, the selection should be a rectangle. You can also hide rows and columns that you don't want to appear in the chart.

      Select cells, ranges, rows, and columns

      To highlight

      Follow these steps

      Single cell

      Click a cell or use the arrow keys to move to the desired cell.

      Cell range

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

      Alternatively, you can select the first cell of a range and then press F8 to expand the selection using the arrow keys. To stop expanding the selection, press F8 again.

      Large cell range

      Click the first cell in the range, and then Shift-click the last cell in the range. Scroll to display the last cell.

      All sheet cells

      Click the button Select all.

      You can also press CTRL+A to select the entire sheet.

      If the table contains data, pressing CTRL+A selects the current range. Pressing CTRL+A again will select the entire table.

      Non-adjacent cells or ranges of cells

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

      You can also select the first cell or range of cells, and then press Shift+F8 to include other nonadjacent cells or ranges in the selection. To stop turning on cells and ranges, press Shift+F8 again.

      Note: You cannot deselect individual non-adjacent cells or ranges without deselecting the entire selection.

      Entire column or row

      Click the timeline or column heading.

      1. Row header

      2. Column header

      You can also select cells in a row or column by selecting the first row and then pressing CTRL+SHIFT+ARROW (RIGHT or LEFT for rows, UP or DOWN for columns).

      If a row or column contains data, pressing CTRL+SHIFT+ARROW will highlight the row or column up to the last filled cell. Pressing CTRL+SHIFT+ARROW again will select the entire row or column.

      Adjacent rows or columns

      Drag your mouse over the row or column headings. You can also select the first row or column, and then press SHIFT to select last line or column.

      Non-adjacent rows or columns

      Select the row or column heading of the first row or column of the selection, and then press CTRL to click the column or row headings that you want to add to the selection.

      The first or last cell in a row or column

      Select a cell in a row or column, and then press Ctrl+ARROW (RIGHT or LEFT for rows, UP or DOWN for columns).

      The first or last cell on a worksheet or in Microsoft table Office Excel

      To select the first cell on a worksheet or in Excel list, press the key combination CTRL+HOME.

      To select the last cell that contains data or formatting in an Excel worksheet or list, press CTRL+END.

      Cells up to the last used worksheet cell (lower right corner)

      Select the first cell, and then press CTRL+SHIFT+END to expand the selection to the last cell in the worksheet you use (bottom right corner).

      Cells before the beginning of the sheet

      Select the first cell, and then press CTRL+SHIFT+HOME to expand the selection to the beginning of the sheet.

      More or fewer cells than there are in the active selection

      While holding down the SHIFT key, click the last cell you want to include in the new selection. The new selection will include a rectangular range between active cell and the cell that was clicked.

      To deselect cells, click any cell on the worksheet.

      To quickly create a chart based on the default chart type, select the data you want and press Alt+F1. Pressing ALT+F1 creates an embedded chart.

      When you create a chart, Excel determines the orientation of your data series based on the number of worksheet rows and columns that are included in it. After creating a chart, you can change the way the rows and columns are displayed in the chart by swapping them.

      If the diagram is not needed, you can delete it. Click the chart to select it, and then press DELETE.

    Step 2: Change the chart layout or style

    Once you create a chart, you can instantly change its appearance. Instead of manually adding or changing chart elements or formatting, you can quickly apply a preset layout and style to your chart. Word provides a variety of useful chart layouts and styles (or Quick Layouts and Quick Styles) to choose from; If necessary, you can further customize the layout or style by manually changing the layout and format of individual chart elements.

    IN Microsoft Office There are a huge number of templates and tools for working with graphics. With their help, you can prepare a beautiful presentation or supplement a document with a visual application. To do this, figure out how to make a diagram in Word. It makes it easier to demonstrate information. If you display numbers and characteristics in the form of 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 correctly designed schedule will be immediately remembered.

    In this article you will learn how to properly format graphs in Word.

    Creating Charts

    Finding the required add dialog is quite simple

    This graphic can be inserted directly into a Word document. In this case, you must enter the data in Excel spreadsheet. It is not necessary to understand all the functions of this program 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 - Drawing). There are all the tools for working with presentations and documents: images, WordArt shapes, multimedia. Find the "Create Chart" option.
    3. Select a visualization type. On the left are the categories: circular, point, exchange, petal, linear, bubble and so on. And on the right you can see what the figures look like. 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 values ​​in the illustration. They present the diagram as text. When you type a character in Excel, it will immediately be reflected in Word. All names are given by default - rename them in the table. For example, instead of the word “Category” write “Indicators for the current year”, and instead of “Row” write the name of the department. And change the numbers to the ones you need. This way you can make a visual graph.
    5. If you lack characteristics, there is no need to insert a new illustration. This is also . The block with numbers, categories and rows in the table is surrounded by a frame. Pull it by the lower right corner - this will expand the diagram. Enter the desired values ​​in the empty cells.

    When you insert an object in a text editor, the table is loaded

    To change an already prepared presentation, you do not need to create it again. It's better to do the following:

    1. Click on the object.
    2. New items will appear in the menu bar. This is a toolkit that allows you to customize your 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. This way you can build a new graph, leaving in it the numbers and names from the old one.
    5. If you want to enter other numbers, then click “Change data”. An Excel table with categories and rows will open. They cannot be retyped directly into Word.

    Basic tools for structured customization on the ribbon

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

    The next tab further expands your capabilities

    Appearance of charts

    There are many illustration templates in Microsoft Office. But if none of them suits you, 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 via context menu, item "Format". Each element can be edited separately. Simply select the part of the object you want to work on.

    More information about the tabs in the menu:

    • Row parameters (or axis parameters). Here you can change the shape of the figures and their location relative to each other.
    • Filling. Choosing the color of the illustration. If you want to make a graph with your own pictures, then place a marker next to the “Drawing” item and click “Insert from file”. You can set textures, gradients, combinations of different shades, and so on.
    • Border styles. Settings for view, fill and frame width. To work with this menu, in the “Border Color” tab, select the “Solid” or “Gradient” line type.
    • Volumetric figure format. You can make the drawing three-dimensional and choose the type of surface it will resemble. But this doesn't work with all elements in Word. It does not apply, for example, to such “Bubble” objects - they are already voluminous.

    In the “Glow” and “Shadow” tabs you can configure the corresponding effects. Experiment and try different settings. The changes will immediately appear in the document. To move text information about series and categories, click the "Legend" button in the "Layout" menu.

    Beautiful presentation design makes its perception more effective

    But you can figure out how to build a diagram in Word and change its appearance without searching for numerous functions. These shapes are similar to the shapes from WordArt. Their individual elements 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 chart.

    This panel has settings for text wrapping. You can insert text into a picture from WordArt and add various effects. To create a unique and memorable diagram, you don’t need to use all the Word tools at once on a small piece of illustration.

    Highlight an important fragment, giving it volume. Place the shadows wisely - this will give the feeling that the rows are at different levels. You can make an element glow to which you want to draw attention.

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

    The graph of a function is a type of diagram in Microsoft applications Office, which displays the relationship of one indicator from another (for example, the cost of an order from the price of a product) or the dynamic metamorphosis of some value (say, the metamorphosis of air temperature over a week).

    You will need

    • - computer;
    • – installed Microsoft Office software package.

    Instructions

    1. Use the add-on for Microsoft package Office to create a graph in Word. This application is called Graph Builder. It allows you to draw a graph of a given function in Word in the form of polylines. Download the add-on from the link http://www.softportal.com/getsoft-1561-postroitel-grafikov-2.html and install it on your computer. Run Word program, build a table with data for the function graph.

    2. Enable the ability to run macros to apply add-ons. To do this, go to the “Tools” menu, select the “Macro” option, then “Security”. In the window that opens, set the security level to low or medium. You also need to install support Visual Basic for Applications.

    3. Enable the Builder button, to activate it, click on the “View” menu, select “Toolbar” - Graph Builder command. Or right-click on any toolbar and check the box next to Graph Builder. Click on the “Launch graph plotter” button, a dialog box will appear on the screen in which you need to set the settings for building a graph in Word.

    4. Check the boxes next to the graph elements that you want to display on the screen. If necessary, enable the display of the grid, axis labels, arrows, and divisions. Near the inscription F(x)=, left-click on the arrow and select the function required for construction.

    5. Place the switch close the required system coordinates (Cartesian or polar). Select the desired construction accuracy (high or medium). Next, set the grid size (enter the required numerical values ​​in the appropriate fields).

    6. Set the required unit of measurement for the graph (points or millimeters). Go to the “Table of Values” tab and in the appropriate fields make a link to the values ​​that need to be used to plot the function graph in Word. Set the desired language and click on the “Draw” button.

    Microsoft Word is perhaps the most popular and best text editor. Therefore, by setting this program to your computer, you can easily solve a variety of tasks. One of the most important features is the creation of schedules, which are necessary for almost every person to work.

    Instructions

  • First you need to run Microsoft program Office, if you have it. If it is not there, then you can download the installer from the Internet or buy a disk at any specialized store. You can download this program from the official website of Microsoft Corporation (http://www.microsoft.com/rus/).
  • After you have launched the program, go to the “Insert” tab, which is located on the toolbar in the left corner of the window.
  • Then find the "Illustrations" section. It will offer you a fairly large list additional modules(for example, shapes, diagram, drawing, clip, etc.) that you can use as you work on your document. In our case, you need to click on the “Diagram” button.
  • As a result, a new window should open in front of you, which will present a large list of chart types: graph, pie, histogram, bar, dot, surface, stock, bubble, donut, radar. You can build all these diagrams with using Microsoft Word 2007. To create a graph, you need to select the appropriate button.
  • Next a small window will appear Microsoft Excel, in which you need to specify certain values ​​​​on which your graph will be built. Don't forget to enter all the names in the graph so that later it will be more convenient for you to work with the values. After confirming the creation of the graph, you will see it on the current page of the document. Edit this schedule you can at any time.
  • If after working with the graph you are not satisfied with its appearance, you can change it to a more suitable one at any time. To do this, right-click on the chart and select “Change Chart Type.” In the new window, click on the appropriate graph type and click OK. Your chart will automatically change its appearance.