How to create a histogram in Excel and Word. How can I create a diagram from Wordi? How to position a diagram in Word
Under the diagram, Word understands the object that is the armchair, which shows the relationship of any quantities. Determine the requirements when writing scientific papers for students of technical knowledge, when preparing a presentation, etc. Our article will show you how to create a diagram in Word in several ways. Before that, we will look at the work option in several versions of Word programs: from 2007 to 2016.
Books, coursework, diplomas, abstracts, dissertations, presentations - any of these works may require folding diagrams. Some freelancers have the idea that it is much more convenient to work in the Excel program, but not everything can be done in one, so today we will look at a number of ways to work in the Word text editor.
How to create a diagram in Word 2010?
The text editor of this version allows you to add several types of diagrams to the document. Whole line chart, circular, point, etc., as well as histograms and graphs. How to add any of the overinsurance objects to the text? All you need to do is follow the following algorithm:
- We know the "Insert" tab on the toolbar.
- Then we come to the “Illustrations” group.
- Now we select an object under the name “Diagram”.
- The "Insert Diagrams" dialog box allows you to select the required object type.
- We select the most suitable option and confirm all the steps by pressing the OK button.
Creating a diagram in Wordi 2016
How can I create a diagram in the new version of Word? In order to create a diagram in a document from scratch, you first need to go to the account - from the “Insert” tab, go to the “Diagram” section. Then you need to select the required type of diagrams: pie, dot, border, histogram, plot or combined.
Next, a spreadsheet will appear on the screen, where you will need to enter the data that you need to display on the diagram. Once everything is entered, close the dialog box. The same functions of Word allow you to edit the placement of diagrams and their size, all in the “Layout Options” section.
Formatting created diagrams
The user can not only select a given template using diagrams, but also format them. Change the color of the contours and fills to add a special effect. How can you earn money?
To create a format, koristuvach can do the following:
- For example, fill the elements with diagrams. This allows you to pay attention to any elements of the object.
- Adjust the color of contours using diagrams. For example, change the color of the contour, its color also.
- Add special effects to your diagrams. For example, add shadow, light, smooth the edges.
- You can also format the text and numbers that appear in the diagram. You can also create WordArt styles for them.
How to create a diagram in Word 2013 and 2016?
To start, on the Word toolbar, select the “Insert” tab, then “Diagram”. Next, the user selects the required type using the diagrams, then presses the OK button. When creating an electronic table, the customer is responsible for all the data that needs to be displayed in the diagram. The diagram will automatically update with each new information entered.
How can I create diagrams in a Word document?
In this section we will look at how to create the names of the diagrams included in the Horde document. To get started, click on the diagram, then click on the “Plus” button. For the registered list, an ensign is inserted opposite the “Names of Diagrams” item. In the “Name of Diagrams” field that appears, enter the required text. This method works for the text editor of 2013 and 2016.
There is another way to get stuck in the 2007 and 2010 program. Click on the diagram. After this, the “Working with Charts” panel will appear on the screen, so you need to select the “Layout” tab. In the group under the name “Signatures”, click on the item “Names of Diagrams”. In the text field you need to enter the text of the object name. To format the text, you need to select the required options on the toolbar menu.
In this article we looked at the nutrition that shows how to create a diagram in Word in various versions and modifications: from 2007 to 2016. As practice shows, it is absolutely not difficult to get back to the basics of the Word text editor with these tasks. The main thing is to strictly follow the instructions given to the algorithm, only in this case the result will not disappoint you, and the robot itself will not cause trouble.
Sometimes, when creating any documents in Word, it is necessary to illustrate the data explicitly. The food is coming:? With it, your document will become clearer, more understandable and will look complete. Moreover, for them to get used to Word there are no tools. The diagram can be created in any shape or color.
Lesson - how to create a diagram in Word
Let’s start by opening the “Insert” tab and finding the “Diagram” key and going there. In the dialog box we are presented with a choice of different forms. They are represented by: histograms, graphs, areas, circles, dots, exchanges and many others. Select something that suits you, click on it and click “OK”.
Select the design using diagrams
Butt diagrams
Two great windows merge: the evil one loses our word, and the right hand one loses the Excel window. Left-handed in our document a diagram appeared, which you chose, right-handed in Ekelevsky’s mental category and series. In whose window you place your data, activating through the middle. Left-handed input the data, and right-handed watch as the diagram changes. If you need to insert additional data, the area can be expanded. Once you have entered all the data, you can close the excel window.
How to create a diagram We got used to it, and now we have to change and format it.
How to change the diagram
Let me first give a name to our chart, for which we activate the words “name of diagrams” and add what is needed in this place. Next, the graph field is activated again, and a work panel with diagrams will appear. There are three sections to help you format and change the data in it. The panel is called “working with diagrams”,
The panel has a lot of tabs, including changing the entire panel. Action axis: designer, format, layout, adjustment and others. This panel will be visible until you start working in the document, and as soon as you activate the field with diagrams by clicking on it with the left mouse button, a panel for working with it will appear.
Return to the "Layout" tab. If you need the data table you created in the Excel window to be displayed below the graph, go to “Layout”, “Data Table”. A dialog box will appear, and here you can select to have the table with the data displayed in any location.
Change the diagram.
In order to learn a lesson about those How to create a diagram in Word, experiment with different data, shapes, colors and tables.
If you want to quickly make changes to the schedule, click on the right-handed mouse button, a dialog box will appear where you can make changes or formatting.
If you need to visualize the folds to understand the data, then a diagram can help you. Using these diagrams, one can easily demonstrate the relationships between different indicators, as well as identify patterns and sequences of evidence.
You may think that to create diagrams you need to use multiple programs, but that’s not the case. For this, a simple word text editor will be enough for you. And this statistic is not demonstrable. Here you can learn about how to create a diagram in Word 2003, 2007, 2010, 2013 and 2016.
How to create a diagram in Word 2007, 2010, 2013 and 2016
If you are using Word 2007, 2010, 2013 or 2016, then in order to create a diagram for you You need to go to the “Insert” tab and click on the “Diagram” button there.
After this, the “Insert Diagrams” window will appear. Whose birthday is it? You need to select the current view of the diagrams you want to insert into your Word document and click on the “Ok” button. For example, let's choose a pie chart.
Once you have chosen the current appearance of your diagrams, your Word document will display an example of how your diagram might look. At this time, the Excel program window will open. In Excel, you will get a small table with data that you can use to create diagrams in Word.
To change the inserted diagram to suit your needs, you need to make changes to the table in Excel. For this purpose, simply enter the official names of the workers and the necessary data. If you need to increase or change the number of rows in the table, you can do this by changing the area shown in blue.
Once all the necessary data has been entered into the table, Excel can be closed. After closing Excel, you select the diagram you need from Word.
Since there is no need to change the data that is being used to prompt the diagrams, then for what You need to see the diagram, go to the “Designer” tab and click on the “Change data” button.
To customize the new look of your diagrams, navigate through the “Design”, “Layout” and “Format” tabs. Using additional tools on these tabs, you can change the color of pictures, captions, text wrapping and many other parameters.
How to create a pie chart in Word 2003
If you are using the text editor Word 2003, then in order to create a diagram for you You need to open the “Insert” menu and select the “Malyunok – Diagram” item there..
As a result, your Word document will have a diagram and table.
To create a pie chart press the right button on the bear behind the diagram and select the menu item “Diagram Type”.
Once the window appears, you can select the appropriate type of diagrams. Otherwise, here you can select a pie chart.
After saving the parameters for the external appearance of the diagrams, you can proceed to changing the data in the table. Click on the left mouse button next to the diagram and a table will appear in front of you.
In addition to this table, you can change the data that you need to use to display the diagrams.
Charts are used to present series of numerical data in a graphical format, which makes it easier to understand a large amount of information and data between different series of data.
1. Data sheet
2. Diagram created according to the data sheet
Excel supports a variety of chart types, allowing you to present data in the most meaningful way for your audience or others. When creating a new or changing existing charts, you can select one of different types (for example, a histogram or a pie chart) and subtypes (for example, a histogram with accumulations or a volumetric pie chart mu). Once you have different types in one diagram, you can create a mixed diagram.
Additional information about the types of diagrams supported in Excel, div. in the Diagram Types section.
Elements diagrams
The diagram is made up of various elements. Some of them are shown below, others can be added as needed. You can change the appearance of the elements in the diagrams by moving them to another location or changing their size or format. You can also remove elements using diagrams that do not need to be displayed.
1. area diagrams.
2. area with diagrams.
3. data points for a series of data shown on the diagram.
5. Places of diagrams.
6. Name the diagrams and axes that can be used in a diagram.
7. Data signature, which can be used to indicate data points in a series of data.
Change basic diagrams according to requirements
Once you have created the diagram, you can change any of its elements. For example, you can change the appearance of the axes, add names to the diagrams, move or add a legend, and also add additional elements.
To change the diagram, you can do the following:
Change the type of axes with diagrams. You can specify the scale of the axes and change the spacing between values and categories. To make it easier to read the diagrams, you can add data to the axis and indicate the amount of space between them.
Adding names and data marks to the diagrams To clarify the appearance of data in diagrams, you can add names of diagrams, names of axes, and data labels.
Adding legends and data tables You can modify or add a legend, change its elements. On some diagrams, you can also display a data table, which displays the legend keys and values presented in the diagram.
Setting up special parameters for different types of diagrams. For different types of diagrams, you can set up different special lines (for example, a growth corridor and trend lines), lines (for example, lines of movement and decline and between declines), data markers, etc.
Assembling ready-made styles and diagram layouts for professional design
Instead of adding or changing chart elements and formatting them manually, you can quickly freeze the finished layout or chart style. Word has a number of ready-made layouts and styles that you can customize or adapt by manually changing the layout or format of other chart elements, such as the chart area, the prompt area, data rows, and the legend.
When you select a ready-made layout, a set of elements (for example, a title, a legend, a data table or data labels) is displayed on it in the first order. You can select a suitable layout from the instructions for a specific type of diagram.
If you choose a ready-made style of diagrams, their formatting is based on the defined theme of the document, so the current appearance of the diagrams is consistent with the color of the themes (set of colors), fonts of those (set of fonts for headings and body text) and effects of those (set of colors) ів and fills), accepted by the organization or specified koristuvachem.
You cannot create custom styles or diagram layouts, but you can create diagram templates to accommodate the required layout and formatting.
Add formatting to diagrams
In addition to creating a ready-made diagram style, you can easily change the formatting of other elements, such as data markers, diagram areas, prompt areas, numbers and text in titles and captions, so you can create the diagram original Yu. You can also create shape styles and WordArt styles, or format shapes and text in diagram elements manually.
To add the format, you can do the following:
Filling elements with diagrams. To enhance the composition of the elements, you can fill them with color, texture, detail or gradient.
Changing the contours of elements with diagrams. To display elements in diagrams, you can change the color, type or line thickness.
Adding special effects to elements using diagrams To give the picture completeness to its elements, you can apply special effects, for example, shadow, reflection, glow, smoothing of edges, relief or volumetric wrapping.
Format text and numbers The text and numbers in titles, captions and inscriptions on diagrams can be formatted in the same way as the text and numbers on arches. To see text or numbers, you can use WordArt styles.
Repeatedly using diagrams to create templates
If you need to thoroughly customize your customized diagram, you can save it as a diagram template (CRTX file) in the diagram template folder. When created with diagrams, you can set the template in the same way as the type created by the diagrams. Diagram templates include diagram types - using them, you can change the type of the current diagrams. In case of the need to frequently set the song template with diagrams, you can save this type of diagram that is used for cleaning.
Act 1. Creation of basic diagrams
A diagram can be added to a Word document in one of two ways: by inserting it, or by inserting Excel diagrams linked to the data in Office Excel 2007. Key features between inserted and linked diagrams. here is where the tributes and stench are saved Updated after inserting into a Word document.
Note: For certain types of diagrams, you need to carefully place the data in Excel boxes. To remove additional views, div.
Inserting diagrams in the same way as in the document
If the Excel diagram is exported to a Word file, it cannot be changed once the output Excel file is changed. The transferred objects become part of the Word file and are no longer part of the output file.
Since the data is entirely saved in one Word document, it’s important to use it if you don’t want it to be changed according to the output file, or if you don’t want the document’s owners to have to update the associated information. atsion.
Inserting linked Excel diagrams into a document
You can create a diagram in an external Excel 2007, copy and paste the linked version into a Word document. As soon as the diagram is linked, the data in it is updated when you change the current Excel key. The associated data is saved in Excel. The Word document saves the output file and displays the associated data.
The connection is also easy to follow if you need to include in the final file records that are saved alongside, for example, data that is collected in another section, or if you need to constantly update the data in the document Word. To view additional information about creating diagrams in Excel, div. Creation by diagrams.
In Excel, select the diagram by clicking on the border, and then on the tab Golovna in the group Clipboard click Virizati.
The diagram will be deleted, otherwise the data will be lost in Excel.
In Word, click on the document where you want to insert the diagram.
On deposit Golovna in the group Clipboard press button Paste.
Button Paste options indicates that the diagram will be linked to Excel data.
Save a Word document with a diagram linked to Excel data.
When you re-open the Word document, click the button So for updating Excel data.
You can also create a clear display of data using SmartArt graphic elements. To remove additional views, div. Creation of a SmartArt graphic element.
Organizing data using Excel
Most charts, such as histograms and line charts, can be based on data spread out in rows or columns of sheets. However, for certain types of diagrams, such as circles and pukhirtsevs, it is necessary for the data to be distributed in order.
See the programs that contain data that you need to use to get the diagrams running.
Porada: If you select more than one option, Excel will automatically create a diagram based on the sum of its entries to accommodate the data. If the required mixtures do not fall into the required range, you may see non-restricted mixtures or ranges; In this case, the vision may be an upright one. You can also add rows and columns that do not need to be displayed on the diagram.
Views of middles, ranges, rows and stations
To see
Sign up for upcoming events
Okremium middle
Click on the item or use the arrow keys to move to the item you need.
Middle range
Click on the first item in the range, and then drag the mouse to the remaining item. You can also press the SHIFT key and expand the visible area behind the additional arrows.
In addition, you can see the first half of the range, and then press the F8 key to expand the visible area beyond the additional arrows. To expand the visible area, press the F8 key again.
Wide range of bitters
Click the first number in the range, and then, using the SHIFT key in the morning, click the remaining number in the range. To view the rest of the middle, scroll down.
All leaf centers
Press button See all.
To see the entire arch, you can press CTRL+A.
When the table contains data, after pressing the CTRL+A keys, the current range is visible. Pressing CTRL+A again will bring up the entire table.
Uncomplicated middles or middle ranges
Select the first company or range of companies, and then press the CTRL key to see other companies or ranges.
You can also select the first selection or range of selections, and then press SHIFT+F8 to highlight other non-commercial selections or ranges. To switch on the middle ranges, press SHIFT+F8.
Note: It is impossible to combine the vision of several interconnected middles or ranges without condensing the entire vision.
Stovpets or the whole row
Click on the title of the term or column.
1. Row header
2. Story heading
You can also see the spots in a row or column by seeing the first row, and then pressing the CTRL+SHIFT+ARROW keys (to the right or left - for rows, up or down - for columns).
If the row or stop contains data, when you press the CTRL+SHIFT+ARROW keys, you will see the row or stop until the remaining filled in middle. Repeatedly pressing the CTRL+SHIFT+ARROW keys will bring you to see the row or stop completely.
Suitable rows or stops
Stretch the mouse behind the headings of the rows or stovpts. You can also see the first row or stop, and then press the SHIFT key to see the remaining row or stop.
Nesmіzhny rows and stops
See the row header or the first row or view column, and then press the CTRL key and click the column or row headers that you need to add to the view.
The first or the last middle in the row or the other
See the box in the row or column, and then press the CTRL + ARROW keys (right or left - for rows, up or down - for columns).
The first or the last center on the arcade or Microsoft Office Excel tables
To see the first item on the box or in the Excel list, press the CTRL+HOME keys.
To see the rest of the list, how to place data or formatting, on the boxes or in the Excel list, press the CTRL+END keys.
Centers to the remaining vicorized center of the sheet (lower right corner)
See the first area, and then press CTRL+SHIFT+END to expand the visible area to the remaining area of the arch (lower right corner).
Hearts to the cob of leaf
See the first patch, and then press the CTRL+SHIFT+HOME keys to expand the visible area to the cob.
More or less middle, lower in active video
While holding down the SHIFT key, click on the remaining box that you want to include in the new visible area. The new area shown is the direct range between the active center and the center that is clicking.
To select the images of the middles, click on the box on the bottle.
Add data to the ark, based on what is needed for the diagram.
Data can be placed in rows or columns - Excel will automatically determine the best way to display the diagrams. For certain types of diagrams, such as circles and bubbles, it is necessary to place the data in order, as described in the table below.
Birzhova diagram
Behind the columns or rows in the offensive order, with the names and dates as signatures:
maximum, minimum and closed values
For example:
Zakrittya |
|||
|---|---|---|---|
|
Maximum |
|
|
Zakrittya |
To quickly create a diagram based on the type of diagrams you need to follow, see the required data and press the ALT+F1 keys. When you press the ALT+F1 key, the diagram is saved.
When created, Excel determines the orientation of the data series based on the number of rows and columns included before it. Once you've created your charts, you can change the way rows and columns are displayed in your charts by swapping them around.
If the diagram is not needed, it can be deleted. Click on the diagram to see it, and then press the DELETE key.
Activity 2. Changing the layout and style of diagrams
After creating the diagrams, you can quickly change their appearance. Instead of manually adding or changing elements of diagrams or formatting them, you can quickly set the finished layout and style to the diagrams. Word provides the ability to choose a variety of basic layouts and chart styles (or express layouts and express styles); If necessary, you can further customize the layout or style by manually changing the layout and format of other elements in the diagrams.
Diagram to word. If you often have to put things together with diagrams, you can't do it without the help of Word. Who thinks it’s easier to work in Excel? Maybe so. In such cases, this is true. If not everyone can work with tabular data, it is easier to use Microsoft Word. The creation of diagrams in Word is in no way different from such an operation in Excel. I’ll write about this later, but for now let’s look at the food for Word.
Diagram inWord 2003
For which you select from the menu – Insert – Malyunok – Diagram .
The following diagram and table will appear on your page.
Right-click on the diagrams section and select “from the list” Diagram type... ».
Select the appropriate type using the diagrams. I was honored with " Kiltseva" Don't forget to press the "" button after making your selection. OK ».
I got this picture.
Click on the picture of the girl with the left mouse button. You may see a sign like this. Here you can change and add your data (names and numbers). After making changes, press the “” key on the keyboard Enter ».
The axis came out in me.
Now let's move on to editing our diagrams. Double-click on the diagram with the left mouse button to make the viewing area appear.
Right-click on the diagram in the middle of the viewing area and in the list that opens, select the first entry “ Diagram area format. ».
In the “Format Diagram Area” window, you can change the fill of the area where the diagram is drawn, the frame of this area, and the font.
What happened to me was the axis.
Now it’s so changeable” Diagram parameters. » (Click the right mouse button in the middle of the visible area of the diagrams).
Open the skin tab and change the ones you need. After you change everything, don’t forget to save your project.
If the diagram turned out to be too small and nothing is visible on it, then stretch it out into little bundles.
Right-click on Legend and select “ Legend format " Don’t forget to see the plot before this with the pictures of the mouse’s sublime clicks.
Change, if necessary, the background color, font and placement of the legend.
If you right-click the mouse button strictly behind the selected scenes, you can change them. Again, don’t forget to see the entire area with diagrams before this.
By clicking the right mouse button, select “ Data series format... ».
Experiment. You can achieve even more results. Try the " Methods of filling » Select a color on the panel.
If you want to change the color of the singing area using diagrams, then you can see this area with one click of the mouse on the cordon (preferably the transverse one, or the shortest one). Then right-click the mouse in the middle of the visible area and select “ Data point format. ».
Select the required color and press the button “ OK" It is easier to change the color to the cob of the mixture.
Everything can be done in different ways. I have described just one of them to you. You'll figure it out for yourself.
Diagram in Word 2007
Businesses are looking forward to working as quickly as possible with the new office package. Let's look at the creation of diagrams in Word 2007.
Inserting diagrams in Word 2007 is slightly different from inserting the same diagrams in Word 2003.
And so let's get started.
For which you select from the menu – Insert – Illustrations – Diagram .
At the website " Inserting diagrams "Select the desired view using the diagrams, then press the button " OK ».
For example, I chose the type "diagrams" The volume is cut circularly " Such a barvisa diagram appeared and an Excel window with a prepared table immediately opened.
If you're running Word 2003, it's much easier to work with. The skin area is easily visible with just one click of the mouse. You can see the skin sector in diagrams and change the color, remove it or rotate it. All you have to do is click on the visible sector with the right mouse button and select the action you need in the menu. For example, I saw the red sector and selected “ Data point format. ».
It appears that you can choose everything that is beneficial to your soul. The choice is great and long-lasting. You don't have to change anything in the row parameters.
And the axis is near the bay, which you will marvel at and stagnate for yourself. I got so caught up in this whole tab that I completely forgot about the ones I was writing. There you go, in a melodious way, you can begin to sing.
Give special respect to “ Gradient fill " Select " Kolir"ta" Names prepared ».
On the upcoming deposit " Color cordon I didn’t change anything.
The style of the cordon has also been removed as it is.
On the deposit " Shade"Deleted your choice.
On the deposit " Volumetric figure format “You can also experiment. All these manipulations must be performed on different colored skin segments.
As a result, I can see what happened. You can get even better results.
If you right-click behind the legend, you can change the color of the font in the small formatting window. And if you vibrate Legend format... ", then you can design your legend no worse than the diagram itself.
Seeing the clicking of the bear, I cover the skin with diagrams, you can format it to your liking. I specially created all the plots in different colors so that you can see what you can see and change.
Now we no longer have to change the data in the table and need to put it on the diagram. To do this, right-click on the mouse in any place and select “ Change details... " An Excel window with a table will open, where you can change the data. I don't think you have any problems here.
By clicking again with the right mouse button on any segment of the stake in our diagrams and selecting “ Add data signatures “You will add to the skin segment what is written in the Legend. And the data in the legend, as you might guess, is taken from the table.
Well, the axis is short, I showed how you can quickly create a perfect diagram in Word. You can earn much more efficiently.
Note
Creating diagrams in Word 210 is in no way different from Word 2007.