General problems with the visibility and display of graphics. Adding a chart to a Word document

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

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

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

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

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

Notes:

Instructions

The appearance of the constructed chart can be changed by making various changes, such as changing the size and location of the chart, adding and deleting data, changing the type and subtype of the chart, changing the font and adding frames for the chart title and axis title, etc.

All these actions can be carried out in the so-called “diagram editing mode”, when switching to which black markers appear in the form of small squares along the perimeter of the frame around the diagram area. To switch to this mode, left-click on any free space diagrams.

The newly created bar chart already has black border markers around the chart area.

It is necessary to exit the diagram editing mode, and then switch to this mode again, for this:

Click with the left mouse button anywhere on the worksheet outside the diagram, as a result of which the black markers will disappear from the diagram.

Click the left mouse button in any free area of ​​the chart (do not select chart elements - legend, chart title, data series, etc.), as a result of which black markers should appear around the entire chart area.

Resizing a chart

To resize a chart:

Move the mouse pointer over the bottom right corner marker of the frame around the chart area so that it changes to a black double-headed arrow.

While holding down the left button, change the size of the constructed diagram so that all its elements are visible (do not enlarge the diagram too much, as it will be brought to the proper form during the editing process).

Moving a chart

To move a chart:

Make sure that the black markers do not disappear from the chart frame (in otherwise highlight the chart area).

By pressing and holding the left mouse button in a free space inside the frame, move the constructed diagram to the lower right corner of the screen so that both the table data and the diagram can be viewed.

Editing diagrams

The diagram is edited separately for each element after its selection. You can select a chart element by placing the mouse pointer on it and clicking once on the left button. The selected chart element will be placed in a frame with black markers around the perimeter. Then, to edit the selected element, you need to call the corresponding dialog box.

Calling the diagram editing dialog box can be done in several ways:

Select a chart element and execute a menu command Format|Highlighted (th, th)…(chart title, series, legend, etc.).

With the diagram element selected, right-click and in the context menu that appears on the screen, select the command Format…(series, chart area, chart title, etc.).

Place the mouse pointer on one of the chart elements and double-click on the left button. In this case, a dialog box for editing the selected chart element will immediately appear on the screen.

Customizing the Display of the Chart Title

You need to change the font of the text and the appearance of the chart title by placing it in a frame. For this:

After placing the mouse pointer on the name of the diagram, click the left mouse button to select this element of the diagram.

By placing the mouse pointer on the frame that appears around the chart title with black markers around the perimeter, press the right button.

In the context menu that appears on the screen, select the command Chart Title Format.

In the dialog box that appears Chart Title Format tab View in option Frame choose another. Right here in the window line type, by pressing the down arrow, select the first option from the list that opens; in the window Color, by pressing the down arrow, select the color you like from the palette (do not select too light colors); in the window Thickness, by pressing the down arrow, select the second option from the list that opens; enable option with shadow. In option fill enable option ordinary and choose the color and fill method to your liking (pay attention to the option Sample in the lower left corner of the tab View, which displays the results of the actions performed). On the tab Font in option inscription choose bold, in option The size install 9. Click OK.

Click the left mouse button in any free place in the diagram and view the result of the actions performed.

Troubleshooting and troubleshooting problems that often occur in connection with the visibility and display of graphics.

Usually, if the object is not displayed in the view, or is not displayed as expected, the problem is incorrect setting visibility. It is better to try to simulate the error in a dataless project. This procedure will help to isolate many of the overlapping visibility issues that come with phasing objects and creating families.

Objects seem to be built incorrectly

To update and rebuild the current image, cut the object out of view, and then paste it, aligned in place. This operation results in an update and troubleshooting of geometry builds for individual instances.

Incorrect display of facade and section tags

To troubleshoot the display of elevation and section tags, try the following steps.

• Zoom out the view in the drawing. See section.
• For scales coarser certain value change the value of the Hide option for the elevation or section instance. See sections and .
• You should check the category of the current view, as well as views whose tags are not displayed. See section.

No grid lines or reference planes visible

To troubleshoot the display of gridlines and reference planes, try the following steps.

• Grid lines and reference planes must be perpendicular to the view in which they are displayed. To see them, go to the appropriate elevation or plan view. See section.
• Grid lines and reference planes must be below the cut plane of the view in which they are displayed. Make sure the clip plane in the view range is not set too low. See section.

Objects not visible

To troubleshoot object display problems, try the following steps.

• On the view control bar, restore the visibility of elements hidden in the view. See section
• On the View Control Bar, change the level of detail for this view. Individual geometry objects are not displayed at certain levels of detail. See section.
• Make sure the view range settings are correct. See section.
• In the Visibility/Graphics Overrides dialog box, make sure the visibility of the objects is turned on. See section
• In the Visibility/Graphics Overrides dialog, click the Filters tab and turn off any applied filters. See section.
• If the project is intended to be shared, in the Visibility/Graphics Overrides dialog, click the Worksets tab and turn off any applied filters. See section.
• If an entire category of objects that are not set to display in grayscale (see section ) is displayed in grayscale, try changing the category for the view. The "Category" parameter determines how different categories of objects are displayed in views specific to different sections ("categories") of the project. Also check the "Coordination" box to display the lines of all objects as solid, without halftones. See section.
• If your project uses stages, set Stage Filter to None. Stages and stages filters affect the display of objects in views. See section.

  Note: Make sure that the instances of demolished objects are phase states, not individual phases. See section.

• You should check the view category to make sure it is not causing some elements to display incorrectly. See section.

Graphics adapter settings

In some cases, the graphics of a view may be affected in some way by the configuration of the graphics adapter or the associated drivers. On the Graphics tab of the Options dialog box, you can view information about the graphics adapter and the current driver for it.

You can also change the "Use Hardware Acceleration" and/or "Apply Line Smoothing" option in the Options dialog box to see if this resolves graphics issues. If you change one of these options, you will need to close the file and open it again for the changes to take effect.

To paste an Excel chart into a Word document, copy it from the clipboard or use the Object command on the Paste menu in Word. When pasting an Excel chart from the clipboard, it will default to an image. The smart tag menu gives the framework the ability to insert a chart, either as an embedded object or as an object linked to a source file.

As with a table, you can select the Word command Special insert Edit menu and then specify the final chart format. If the chart is copied from an Excel workbook chart sheet, the following formats are available; Diagram Microsoft Office Excel (object) ( Microsoft Excel Chart Object), Picture (Picture), Bitmap (Bitmap) and Windows Metafile (EMF) (Picture (Enhanced Metafile)). When pasted in object format, the entire Excel workbook is embedded, not just the chart sheet, which makes the Word document much heavier (especially if the Excel workbook contains a large amount of additional information). The other three options create pictures, the Picture format is the most economical in terms of memory consumption, but you should, based on the results of experiments, choose the most suitable format for the current Word document. When you copy a chart embedded in excel sheet(to do this, you first need to select the chart area in the sheet), the Picture and Bitmap formats will not be present in the Paste Special menu.

SOLUTION OF PROBLEMS -

If the screen is set a high resolution and you are copying a chart sheet adjusted to fit the window, you may be trying to put more pixels on the clipboard than your system can handle. If, under such conditions, a diagram is inserted into Word, its cropping is not excluded. To solve this problem, go back to Excel, embed the chart on another sheet (right-click the chart, select Location from the context menu, and select the sheet), and then copy the resulting embedded chart. If the chart is still clipping in Word, try reducing the size of the embedded chart in Excel.

To make changes to a chart embedded in a Word document as an object, double-click on it. Since Word embeds all Excel workbook, you will have access to both the original chart and the accompanying data. Thus, you can change both the appearance of the chart (that is, the formatting options) and the data displayed on it.

When you start editing an embedded object in Word that originates from a chart embedded in an Excel sheet, you will find that Excel displays the chart on a separate chart sheet. Don't let this bother you, nothing unspecified by you will happen to the original book, since you are working only with a copy, not with the original.

To link an Excel chart into a Word document, in Excel choose Copy from the Edit menu. Then select Word's Paste Special command from the Edit menu. Specify the target format, set the radio button to Paste Link, and then click OK. Any format is suitable for linking a chart except Windows Metafile (EMF).

An Excel chart can be embedded in another way: in Word, execute the Object command from the Insert menu and then select the object type Microsoft Chart Office Excel on the Create tab of the Insert Object dialog box. Word will first display the stub chart shown in Figure 1. 23.8. Knowing that it is unlikely that the data on the cost of food, gas and accommodation for the months from January to June are relevant for you, Word immediately turns on editing mode. It is reasonable to replace this revealing information in the worksheet with your own data. In the Excel window, you will find one worksheet (Sheet1) and a chart sheet (Diagram1) with a blank.

Rice. 23.8. When you select the Object command from the Insert menu, Word provides you with a template for creating your own diagram.

Charts help represent numerical data in graphic format, greatly simplifying the understanding of large amounts of information. You can also use charts to show relationships between different data series.

Component office suite from Microsoft Word program, also allows you to create charts. We will describe how to do this below.

Note: The presence on the computer installed software product Microsoft Excel provides advanced charting capabilities in Word 2003, 2007, 2010 - 2016. If Excel is not installed, Microsoft Graph is used to create charts. The chart in this case will be presented with related data (table). In this table, you can not only enter your data, but also import them from text document or even paste from other programs.

There are two ways to add a chart to Word - embed it in a document or insert an Excel chart that will be linked to the data on an Excel sheet. The difference between these charts is where the data they contain is stored and how it is updated immediately after being inserted into MS Word.

Note: Some charts require a specific arrangement of data on an MS Excel sheet.

How to insert a chart by embedding it in a document?

An Excel chart embedded in Word will not change even if you change source file. Objects that have been embedded in the document become part of the file, ceasing to be part of the source.

Given that all data is stored in a Word document, it is especially useful to use embedding in cases where you do not need to change this very data, taking into account the source file. Also, embedding is best used when you do not want users who will work with the document later to have to update all related information.

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

2. Go to the tab "Insert".

3. In a group "Illustrations" select "Diagram".

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

5. Not only the chart will appear on the sheet, but also Excel, which will be in a split window. It will also display sample data.

6. Replace the sample data provided in the Excel split window with the values ​​you need. In addition to data, you can replace examples of axis labels ( Column 1) and legend name ( Line 1).

7. After you enter the required data in the Excel window, click on the symbol "Changing data in Microsoft Excel» and save the document: "File" — "Save as".

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

This is just one of the possible methods by which you can make a chart according to a table in Word.

How to add a linked Excel chart to a document?

This method allows you to create a chart directly in Excel, in an external sheet of the program, and then simply paste its associated version into MS Word. The data contained in the linked chart will be updated when changes/updates are made to the outer sheet in which it is stored. Word itself stores only the location of the source file, displaying the associated data presented in it.

This charting approach is especially useful when you need to include information in your document for which you are not responsible. This may be data collected by another person who will update it as necessary.

1. Cut out the chart from Excel. This can be done by pressing the keys "Ctrl+X" or with the mouse: select the chart and click "Cut out"(Group "Clipboard", tab "Home").

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

3. Insert a chart using the keys "Ctrl+V" or select the appropriate command in the control panel: "Insert".

4. Save the document with the chart inserted into it.

Note: The changes you made to the original Excel document(outer sheet) will immediately appear in the Word document where you inserted the chart. To update the data when the file is reopened after closing it, you will need to confirm the data update (button "Yes").

In a specific example, we examined a pie chart in Word, but in this way you can make a chart of any type, whether it is a graph with columns, as in the previous example, a histogram, a bubble chart, or any other.

Change the layout or style of a chart

You can always change appearance chart you created in Word. It is not at all necessary to manually add new elements, change them, format them - there is always the possibility of using a ready-made style or layout, of which there are a lot in the arsenal of Microsoft's program. Each layout or style can always be changed manually and customized to meet the necessary or desired requirements, and you can work with each individual element of the chart in the same way.

How to apply a ready layout?

1. Click on the chart you want to edit and go to the tab "Constructor" located in the main tab "Working with charts".

2. Select the chart layout you want to use (Group "Chart Layouts").

3. The layout of your chart will change.

How to apply a preset style?

1. Click on the chart you want to apply the preset style to and go to the tab "Constructor".

2. Choose the style you want to use for your group chart "Chart Styles".

3. Changes will immediately be reflected in your diagram.

This way you can change your diagrams on the go, choosing the appropriate layout and style, depending on what you need. this moment. For example, you can create several different templates to work with and then modify from them instead of creating new ones. (we'll talk about how to save charts as a template below). For example, you have a graph with columns or a pie chart, by choosing the appropriate layout, you can make a percentage chart out of it in Word.

How to manually change chart layouts?

1. Click on the chart or individual element whose layout you want to change. You can do it the other way too:

• Click anywhere on the diagram to activate the tool "Working with charts".
• In the tab "Format", Group "Current Fragment" click on the arrow next to "Chart elements", after which you can select the desired item.

2. Tab "Constructor", in a group "Chart Layouts" click on the first item "Add Chart Element".

3. From the drop-down menu, select what you want to add or change.

Note: The layout options you choose and/or change will only apply to the selected chart element. If you have selected the entire diagram, for example, the parameter "Data Labels" will be applied to all content. If only a data point is selected, the changes will be applied exclusively to it.

How to manually change the format of chart elements?

1. Click on the chart or its individual element whose style you want to change.

2. Go to the tab "Format" section "Working with charts" and perform the required action:

How to save a chart as a template?

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

To do this, simply right-click on the chart and select "Save as Template".

In the window that appears, select a save location, give the desired file name, and click "Save".

That's all, now you know how to make any diagram in Word, embedded or linked, having a different appearance, which, by the way, can always be changed and adjusted to your needs or necessary requirements. We wish you productive work and effective learning.