the main › Wallpaper › Using a computer program, make two charts. How to create a diagram in Microsoft Word. Sales volume by region

Using a computer program, make two charts. How to create a diagram in Microsoft Word. Sales volume by region

1. Create in text editor Word. 1 Next Table:

1 Work is performed in limited functionality mode.

3. Highlight the table. On the Insert tab in the illustration group, select the chart command.

A columnar diagram appears, showing the depth of the listed lakes, as well as another table with the source data.

4. Run the diagram diagram command command. In the dialog box that opens, select the headlines tab, in the appropriate input field, enter the name "Drop of Lakes" diagram; On the Legend tab, select the Add Legend check box and activate one of the switches as you specify its location. Click on the OK button.

5. Install the mouse pointer outside the area of \u200b\u200bnew objects and click the left mouse button.

6. Save the file in your personal folder under the name of the depth.

Task 1 (Linux)

1. Create the following table in the OpenOffice.org Writer text editor:

2. Fill in the table based on the following information:

3. Select the table and execute the insert-chart command. A histogram (bar chart) appears, on which the depth of the listed lakes will be shown, as well as the chart master window.

4. In the chart wizard window, click on the Next button. Set the dataset in the rows. Pay attention to how the diagram changes.

5. In the chart wizard window, double-click the Next button. In the appropriate input field, enter the name "Drop of Lakes" diagram; Check the Show Legend and activate at your discretion one of the switches specifying its location. Click on the ready button.

6. Install the mouse pointer outside the diagram area and click the left button. Drag the diagram in the right place.

7. Save the file in the personal folder under the name of the depth and close the program.

Task 2.

Attention! When entering Units of Square (km 2), activate the button Powder sign.

2. Table Build film chart (see p. 3-5 tasks 1).

3. Save the file in your personal folder under the name area.

Task 3.

1. In a text editor, make the following table:

2. Fill in the table based on the following information:

3. Table Build a column chart.

4. Re-highlight the table, click on the Add Chart button and in the Chart menu, execute the Type Type Type.

5. In the Chart menu, select the Chart Parameters command. In the window that opens, select the Data Signature tab, in the Signature Signature Group, activate the Scheduler switch.

6. Save the file in your personal folder under the evaluation name.

Task 4.

1. In the text editor, submit the following information in tabular form:

2. On the table Build a circular chart of Ocean Square. Provide the output of the name of the chart, legends and expressed as a percentage of the contribution of each ocean in the Water of the World Ocean (Team Chart Parameters).

3. Save the file in your personal folder under the name of the oceans.

Task 5.

1. In the text editor, submit the following information in the form of chart. Diagram Type Select yourself.

2. Save the file in your personal folder under the name of the land.

3. If you have access to the Internet, send the land file e-mail Computer science teacher.

Now you can do

create a chart on the table;
set the chart parameters in the dialog box;
change the type of diagram.

Kalimullina R.V.

Development of a lesson in computer science in grade 9. Subject: "Building diagrams and graphs in Excel."

Objectives: -

Training:

introduce students with the algorithm for building diagrams and graphs in the Excel table processor;

teach build graphs and charts in the Excel table processor;

secure knowledge on the topic when performing a practical task.

Developing:

form analytical and logical thinking of students;

develop the ability to allocate the main thing to find an error;

develop the ability to compare, compare.

Educational:

bring up a careful attitude to a computer, compliance with TB;

education of love for native edge

Type of lesson:combined lesson.

Lesson plan.

1. Organizational moment. (2 minutes.)

2. Repetition of the previously studied material. (7min.)

3. Study of the new material (13 min)

4. Fastening a new material. (15 min.)

5. Summing up the lesson. (2 minutes.)

6. Homework (1 min.)

During the classes.

1. Organizational moment: 2 min

The epigraph of our lesson will be a Chinese proverb

"I hear - I forget,

I see - I remember

I do - I understand "

Chinese proverb

I misunderstoodly took the epigraph to the lesson in the Chinese proverb. Today I hear verbs, I see, I do, will accompany us the whole lesson. You will listen to, see and do.

2. Reiteration.Work in groups: (10 min)

The 1st group receives the crossword, the second group of the test, the 3rd group works with the definitions of "pick up correct."

So, the time to fulfill the tasks has expired (discussion of work performed).

3. Studying a new material.

The teacher formulates the purpose of the lesson: Today, at the lesson, we will study the principle of building diagrams in Excel using a chart master.

Tell me, did you ever have already come across diagrams? And where did you meet with them? Guys, tell me, why do we need diagrams?

Charts clearly reflect the dependence between the data, which facilitates perception and helps when analyzing and comparing the results (Write in the notebook).

Remember what diagrams did you build?

Guys, what was needed to build and diagrams?

Well done. How much it was necessary to make efforts for this, it was necessary to find and build points, I needed a ruler, a pencil, if this is a schedule, when building a diagram, we needed transport, color pencils, a circulation, rubber band.

Today in the lesson we will simplify our task. We will learn to build diagrams very quickly and simply using a computer.

To the lesson Prepared a mini-project "Charts and its types" Student's performance.

In order to build a diagram, first of all we need :

create a table with data and highlight the range of cells;

call Masterdiagram;

on the menu Insertyou need to choose a command Diagramor click on the button Master Charton the Standard toolbar .

Using four dialog boxes Master Chartcollect all the information necessary to build a chart.

Step 1: Choosing a type of diagram.

Step 2:setting source data charts.
Step 3:set the parameters of the diagram.
Step 4:placement chart.
So, let's make the algorithm for building graphs and charts in excel program And write it in the notebook.

To create the diagram, we need:

3. Run the master charts.

4. Select the type of diagram.

Fizminutka for eyes.

And now, I believe that our theoretical knowledge can be consolidated in practice.

4. Fastening a new material.

Now guys go for computers. Do not forget the TB rules

To build diagrams for you a selection of data is made:

Lakes of the Southern Urals

Factors affecting human health.

Graphic solution equation.

Carefully look at this data and tell me what kinds of diagrams would you use to visualize data?

Demonstration of the presentation of the "Lake of the Southern Urals".

5. Working for computersbuilding diagrams.

Guys, you built a histogram of the ratio of the area of \u200b\u200bvarious lakes of the Southern Urals. Thus, it can be clearly possible to determine which lake takes the large area, has the greatest depth. Tell me, please, what lake is the biggest?

A circular diagram can be distinguished by a factor that has the greatest impact on human health (healthy lifestyle). On the graphic function

y \u003d x 2 + 4x-5. You can define the roots of this equation.

Guys, when watching a presentation, we recorded in the notebook algorithm for constructing a chart. Repeat the main stages of constructing charts:

1. Create a table with numeric data.

2. Select the required range of data.

3. Run the master charts.

4. Select the type of diagram.

5. Set the main and extra options Charts (perform steps 1 - 4).

6. Format and edit the diagram areas, if necessary.

5. Summarizing

Tell me, what is the chart? What types of charts do you know? All of you have worked well today, coped with the tasks: learned how to build diagrams

6. Homework:

1. § 21 Repeat, learn entries in the notebook.

2. And as a homework, I offer you independently from the press materials or from the Internet, choose data on the last census of the 2002 population in the Chelyabinsk region and build different types diagrams. You can choose the following criteria: the national composition (% of the total population), urban and rural population, the ratio of men and women, the able-bodied population, the level of education of the population.

Charts help represent numeric data in graphic format, significantly simplifying the 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:Availability on the computer installed software Product Microsoft Excel. Provides advanced features for building charts 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). In this table, you can not only enter your data, but also import them from text document Either inserting out of other programs.

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 document Word.It is especially useful to use the implementation in cases where there is no need to change these data with 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.

2. Go to the tab "Insert".

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

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

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.

6. Replace the example of the data presented in the Excel separated window to the values \u200b\u200byou 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".

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

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 "The main").

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

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

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 appearance The charts 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".

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

3. The layout of your diagram will change.

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.

So you can change your diagrams what is called on the go, choosing a suitable layout and style, depending on what is required in this moment. For example, you can create several different templates to work, and then change from, instead of creating new (On how to save charts 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 manually change the layouts of charts?

1. Click on the diagram or separate elementwhose 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:

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 diagram in right-click Mouse 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.

Chart in Word. If you often have to make some reports with charts, then without Word's help can not do. Many people think that in Excel it is more convenient to do. May be so. In some cases it is justified. But not everyone knows how to work with tabular data, therefore, they prefer easier in circulation - Microsoft Word. Creating a chart in the Word is no different from such an operation in Excele. But I will write about it, but for now, consider this question for Word.

Diagram B.Word. 2003

To do this, select in the menu - Insert - drawing - diagram .

The diagram appears on your page.

Right-click on the diagram area and in the drop-down list, select " Type of diagram ... ».

Select the suitable type of diagram for you. I like it " Ring " Do not forget to press the button after selecting. OK ».

I have such a picture.

Click the diagram twice with the left mouse button. You must have such a sign. It can be changed in it and add your data (names and numbers). After the changes, press the keyboard key " ENTER ».

That's what I did.

We now move on to edit our chart. Click twice with the left mouse button on the diagram to appear the selection area.

Click right-click on the diagram inside the selection area and in the list that opens, select the first record " Format area diagram ... ».

In the "Diagram Format" window, you can change the fill of the area on which the diagram is located, the frame of the same area and the font.

That's what happened to me.

Now we will change the same way Chart Parameters ... "Right-click within the selected diagram area).

Open each tab and change what you need. After all change failure to keep your project.

If the diagram turned out to be very small and nothing really can be seen on it, then stretch it out for corners.

Right-click on the legend and select " Format legend " Do not forget to allocate the area of \u200b\u200bthe chart double with a double mouse.

Change, if necessary, the background color, font and placement of legends.

If you right-click strictly at certain places of chart, you can change them. Again, do not forget before this allocate the entire chart area with a double click of the mouse.

By right-clicking, choose " Format of data series ... ».

Experiment. You can achieve very interesting results. Try the button " Methods of fill "When choosing a color on a palette.

If you want to change the color defined area Charts, then highlight this area with one click on the border (better transverse, i.e. the shortest). Then right-click within the selected area and select " Data point format ... ».

Select the desired color and click " OK " The color is more convenient to change at the very beginning of the diagram creation.

All this can be done different ways. I described you only one of them. Then you already figure it out.

Chart in Word 2007

Some prefer to work with new office package. Therefore, consider creating a diagram in Word 2007.

Inserting charts in Word 2007 is slightly different from the insertion of the same chart in Word 2003.

And so bend.

To do this, select in the menu - Insert - illustration - chart .

In the window that opens " Insertion chart »We choose the necessary type of diagram, and clicks the" OK ».

For example, I chose the type of diagram " Volumetric cut circular " This colorful diagram appeared and at the same time an Excel window opened with a table blank.

Unlike Word 2003, it is more convenient to work here. Each area is easily highlighted with one click. You can select each diagram sector and change the color, delete it or turn it. It is enough to click on the dedicated sector with the right mouse button and in the drop-down menu select the need you need. For example, I highlighted the red sector and chose " Data point format ... ».

This window will open, in which you can choose all your soul. The choice is pretty much and very interesting. In the parameters of the row, you can change anything.

But in the pouring there is something to see and apply for yourself. I was so fascinated by this tab, which even forgot about what I am writing an article. You will probably capture you too.

Especially pay attention to " Gradient fill " Select " Color "And" Name of the workpiece ».

On the next tab " Border color "I didn't change anything.

Border styles also left as it is.

On the tab " Shadow "Made a choice.

On the tab " Format of volumetric figure "You can also experiment. All of these manipulations must be done with each multicolored segment.

As a result, I got what happened. You can get even better.

If you right-click on the legend, then in the small formatting window you can change the color of the font. And if you choose " Format Legends ... "You can make your legend not worse than the diagram itself.

Having a click of the mouse each separate section of the chart, you can format it to your taste. I specifically all sections made different colors so that you clearly can be seen what you can highlight and change.

Now we have only to change the data in the table and if you need to apply them to the diagram. To do this, right-click anywhere in the diagram and select " To change the data… " The Excel window opens with a table in which you can change the data. I think that you have no problems here.

By clicking on the right mouse button on any segment of our diagram and choosing " Add data signatures "You add to each segment, what is written in legend. And in the legend, the data, as you yourself guess, fall from the table.