Plotting diagrams in OpenOffice Writer. OpenOffice Calc Charts How to make a chart in an open document

Diagrams of any type are objects that are used in electronic documents in order to present arrays of numerical data in a convenient graphical format that makes it much easier to understand and assimilate a huge amount of information and connections between different data.

So let's take a look at how you can create a chart in OpenOffice Writer.

It is worth noting that in OpenOffice Writer you can insert charts only based on information obtained from the data table created in this electronic document.
The data table can be either created by the user before creating a chart, or during its construction.

Creating a chart in OpenOffice Writer with a previously created data table

Open the document in which you want to create a chart
Place the cursor in the data table that you want to chart. That is, in the table whose information you want to visualize
Next, in the main menu of the program, click Insert An object — Diagram

The Chart Wizard will appear on the screen.

Specify the type of chart. The choice of chart type depends on how you want to visualize the data
Steps Data range and Data series can be skipped, as by default they already contain the required information

It is worth noting that if you need to build a diagram not for the entire data table, but only for some specific part of it, then at step Data range in the field of the same name, you must specify only those cells on which the operation will be performed. The same goes for the step Data series where you can specify ranges for each data series

At the end on a step Chart elements specify, if necessary, the title and subtitle of the diagram, the title of the axes. Also here you can select whether to display the legend of the chart and the grid along the axes

Creating a chart in OpenOffice Writer without a pre-created data table

Open the document in which you want to embed the chart
In the main menu of the program, click Insert, and then successively press An object — Diagram... As a result, a chart filled with template values will appear on the sheet.

Use a set of standard icons in the upper corner of the program to adjust the diagram (indicate its type, display, etc.)

Pay attention to the icon Chart data table... After clicking it, a table will appear on which the diagram will be built.

It is worth noting that both in the first and second cases, the user always has the opportunity to change both the data of the diagram, its appearance, and add other elements to it, for example, labels

As a result of these simple steps, you can build a diagram in OpenOffice Writer.

Now it remains to insert the diagram of our calculation. This is done very simply:

Highlighted two columns A and B... The item is selected from the menu Insert-> Chart ...

In our case, the first line is the axis label x, so we leave a check mark First line as signature... The range of values recorded in the field Region, was determined automatically, it, as expected, is equal to $ Sheet1. $ A $ 1: $ B $ 361.

Our diagram can be placed either on one of the existing sheets, or on a new sheet. If you place a diagram on a new sheet, then it will occupy it completely, which is very convenient for printing diagrams on a whole sheet. In our example, selected to place the chart Sheet1.

After filling in each dialog box, the button is pressed Further.

In this window, the type of diagram is selected from the following possible:

2D charts

lines;
with areas;
bar graph;
ruled;
circular;
XY chart;
mesh;
exchange.

3D charts

3M chart;
with areas 3M;
3M histogram;
ruled 3M;
circular 3M.

Since the diagram is being built in two columns, we select the XY-diagram. Data series are specified in columns.

In this window, the version of the diagram is refined.

Let's indicate the name of the diagram; since there is only one dependency on it, uncheck the legend box. Enter the labels for the X and Y axes.

Target:

1) educational

Teach how to create tables and plot graphs in OpenOffice.org Calc.
To teach the skills of working on their design.
Fasten the material practically by completing the task on the PC.

2) educational

Fostering a sense of the new, progressive; objectivity, resourcefulness, discipline.
Education of industriousness.
Instilling in students the skills of independence in work.

3) developing

Development of cognitive interest.
Development of logical thinking, attention.
Formation of information culture, computer literacy and the need to acquire knowledge.

Occupation type: assimilation of new material.

Interdisciplinary connections: mathematics, Russian, economics.

Knowledge assimilation level: skill and skills.

Control: to perform practical actions.

Providing classes: instructions for practical work.

General information

1. Graph (Diagram) XY

XY chart in its basic form is based on a single data series consisting of a name, a list of values X and a list of values Y... Each pair of meaning (X, Y) displayed as a point in the coordinate system. Data series name is associated with values Y and is indicated in the legend.

XY chart solves the following tasks:

axis scaling X;
creating a parametric curve, such as a spiral;
creating a function graph;
study of the statistical relationship of quantitative variables.

XY chart can contain multiple data series.

Option XY charts can be selected on the first page Chart Wizards or along the way Format -> Chart Type for diagram in edit mode.

The chart is created using the default settings. After creating a chart, you can edit its properties to change the appearance. Line styles and icons can be changed in the tab Line in the data series properties dialog box.

Double clicking on any data point will open a dialog box Data series... This dialog box allows you to change many of the properties of the data series.

For 2D charts, you can choose here Insert> Error Bars for Y, to enable the display of error bars.

Using menu commands "Insert" you can turn on the display of average value lines and trend lines.

Points only

Each data point is indicated by an icon. V OpenOffice.org standard icons with different shapes and colors are used for each data series. Standard colors are set in the menu Tools -> Options -> Charts -> Standard Colors.

Only lines

In this variation, straight lines connect one data point to another. Data points are not indicated with icons.

The order of the figure is the same as the order in the data series. Option Sort by X values allows you to draw lines in order of values X... This sort does not apply to the data in the table, but only to the chart.

Lines and points

This option displays both points and lines at the same time.

3D lines

Lines are displayed as ribbons. Data points are not indicated with icons. In the finished diagram, you must select 3D view to set properties such as lighting and viewing angle.

Smoothing lines

Option Smoothing lines allows you to draw curves instead of straight lines.

You must choose Properties to set additional curve parameters.

Cubic spline interpolates data points with third degree parabolas. The transitions between the fragments of the parabola are smoothed and have the same slope and curvature.

Permission determines the number of line segments calculated to create a chunk of a parabola between two data points. By clicking on a data point, intermediate points are displayed.

Bi-spline uses data points as control points to form a bi-spline curve. These curves are formed from parabolas. Function Data point order sets the degree k these parabolas.

Work order

Exercise 1.

Plot Linear Function y = 3.65x-1.5 .

For this:

1. Run OpenOffice.org Calc .

2. On the first sheet, create a table based on the sample.

3. Rename the shortcut Sheet 1 by giving it the name “ Schedule 1”.

4. Plot a linear function y = 3.65x-1.5 on the interval [-6.6] using Chart wizards by choosing in step 1, the chart type is XY Chart (lines only);

in step 2, when selecting a data range, set Data Series in Rows;

in step 4, enter the chart elements: heading “GRAPH y = 3.65x-1.5”, show the legend on the right, display the grid along the X and Y axes.

5. Format the plotted graph.

Fill the chart area with a gradient and set a border for it.

6. Fill the legend area with a texture and set a border for it.

7. Insert data labels.

To do this, click on the required row and run Insert -> Data Signature.

8. Produce axis format X .

For this:

Click on PKM along the axis X and select Axis format ... from the context menu.
In the tab Scaling the window that appears X-axis

In the tab Line fit for axle NS 0.10 cm .
Press Ok .

9. Produce axis format Y .

For this:

Click on PKM along the axis Y and select Axis format ... from the context menu.
In the tab Scaling the window that appears Y-axis install as shown in the figure:

In the tab Line fit for axle X solid blue line wide 0.10 cm .
Press Ok .

10. Produce the format of the main axis grid X .

For this:

Click on PKM along the main axis grid X and select Main grid format from the context menu.
In the tab Line the window that appears Main axis grid X 0.05 cm .
Press Ok .

11. Produce the format of the main axis grid Y .

For this:

Click on PKM along the main axis grid Y and select Main grid format from the context menu.
In the tab Line the window that appears Main axis grid Y set a solid line to red with a width 0.05 cm .
Press Ok .

12. Generate Axis Complementary Grid Format X .

For this:

Click on PKM along the additional grid of the axis X and select Format add. nets from the context menu.
In the tab Line the window that appears Additional axis mesh X set a solid line to black with the width 0.01 cm .
Press Ok .

13. Increase the size of the graph proportionally.

For this:

Move the mouse pointer over one of the eight sizing handles on the chart frame so that it turns into a double-headed arrow.
Press the key Shift and Paintwork and drag the marker to the desired chart size.

14. Save the resulting file under the name Plots.ods .

Task 2.

Plot a function graph y = sin2x on the interval [-10.10].

For this:

1. Open the file Plots.ods ... Go to the second sheet by clicking on the shortcut Sheet 2 .

2. Rename the shortcut Sheet 2 by giving it the name “ Schedule 2 ”.

3. Plot the function y = sin2x on the interval [-10,10] using Diagram wizards (see item 4 of task 1).

The table of values for the function can be built both horizontally and vertically.

In this case, the table of values for the function y = sin2x build vertically.
To plot this function, enter the following expression in the formula bar: = SIN (2 * X) or = SIN (2 * A2).
Smooth the line.

As a result, you should get:

4. Format the plotted graph by repeating the steps items 5-13 of task 1 .

5. Re-save the resulting file with the same name Plots.ods .

Task 3.

Solve the system of equations graphically

For this:

1. Open the file Plots.ods ... Go to the third sheet by clicking on the shortcut Sheet 3 .

2. Rename the shortcut Sheet 3 by giving it the name “ Schedule 3 ”.

3. Plot function graphs and with the help Chart Wizards .

Build tables of values of these functions and their graphs as follows:

4. Format the plotted graphs by repeating the steps items 5-13 of task 1 .

5. Re-save the file with the same name Charts.xls .

Control questions:

1. What tasks can be solved using XY charts ?

2. What the option allows Smoothing lines v XY chart?

3. What actions can be performed when formatting axes X and Y?

4. What is "Autocomplete" and when is it used?

5. How can I delete a chart (graph)?

Select the data range containing the X and Y values, call the Chart Wizard.

Step 1. We select the type and type of the diagram "XY Diagram" (Fig. 44). Push Next >>.

Rice. 44. First Step of the Chart Wizard in OpenOffice.org Calc

Step 2. We mark the first column as a signature (Fig. 45). Push Next >>.

Rice. 45. Second Step of the Chart Wizard in OpenOffice.org Calc

Step 3. We indicate the names of the rows in the field Range for: Name by selecting the appropriate row in the box Data series(fig. 46).

Rice. 46. The third step of the Chart Wizard in OpenOffice.org Calc

Step 4. We enter the names of the axes in the appropriate fields, and then click on the button Ready, we get the required diagram (fig. 47).

Rice. 47. Scatter chart built in OpenOffice.org Calc

To insert a trend line, open the context menu by clicking on the required data series on the chart. We choose Type of regression and note Show coefficient of determination (R 2).

Fig. 48. Adding a trendline in OpenOffice.org Calc

We get the diagram as in fig. 49.

Fig. 49. Scatter plot with trend line in OpenOffice.org Calc

In the case of 11 b, the R-square slightly exceeds the border of insufficient accuracy, which indicates the presence of an average linear relationship between the proportion of classes in an interactive form and motivation to achieve success in this class.

Practical task 4. Development of the Ishikawa diagram using the method of rationing

for calculating relative weight coefficients by the standardization method

The calculation of the weights of the factors of the Ishikawa diagram is carried out within the framework of hierarchical levels and separately for the factors of a particular branch-group (sub-branch-subgroup).

Factors Ф 1 - Ф n, subject to expert assessment, are written out against a scale marked in percentages or relative values from 0 to 1 or in any other (for example, 5-point) scale. The expert is invited to connect each factor with a line with the required (in the expert's opinion) point of the scale. It is allowed to draw several lines to one point of the scale (Fig. 50).

Rice. 50. Method of valuation

The results of a survey of several experts are summarized in a survey matrix (Table 10).

Table 10

Multiple Expert Interview Matrix

Expert	Factor	Sum
		…	j	…	n
… I… m	b 11 b 21… b i1… b m1	b 12 b 22… b i2… b m2	… … … … … …	b 1j b 2j… b ij… b mj	… … … … … …	b 1n b 2n… b in… b mn	B 1 B 2… B i… B m

Then the following sequence of actions is performed:

The sum of the weights given by the i-th expert to all factors is calculated,

The relative weight of the j-th factor is calculated based on the assessment of the i-th expert

The resulting weight of the j-th factor is calculated

Let's consider the calculation of weights using a small example. There are two groups of factors influencing the results of control of academic performance (Fig. 51).

Rice. 51. Ishikawa diagram for reasons influencing the results of monitoring of academic performance

Table 11 shows the results of a survey of four experts on the degree of importance of three factors of the group "Form, means and methods of control", assessed on a 100 point scale.

Table 11

Poll matrix

We calculate the sum of points for all experts (in Fig. 52, column E)

Rice. 52. Calculation of the amount of points for experts

Next, we calculate the relative weights of all factors for each expert. In fig. 53 is a new created table, in which the first value for the first Expert Advisor is calculated using the formula = B3 / $ E3, the rest are filled in by dragging the formula to the right and down.

Rice. 53. Calculation of the relative weights of factors for each expert

We calculate the resulting relative weights of the factors (Fig. 54).

Rice. 54. Calculation of the resulting relative weights

The weights obtained indicate that the most important in the group of factors "Form, means and methods of control" is the quality of control materials (0.43), then the subjectivity of the assessment procedure (0.29), and in last place, with a minimum margin, is the assessment method (0 , 28). The sum of points is equal to one.

The calculation of the weights of the groups of factors is based on the same sequence of actions of the expert standardization method. It should be borne in mind that the groups of factors themselves, most likely, will not be equivalent, which means that the obtained weight values of the factors should be recalculated taking into account the weight of the groups of factors. For example, if as a result of calculations it turned out that the group of factors "Form, means and methods of control" received a weight of 0.4 according to experts, then the final values of the weights of all factors should be recalculated by multiplying the initial estimates by 0.4:

quality of control materials 0.43 * 0.4 = 0.172;

subjectivity of the assessment procedure 0.29 * 0.4 = 0.116;

assessment method 0.28 * 0.4 = 0.112.

The total of points in this case is 0.4.

Based on the results of the assessment, the Ishikawa diagram will look like in Fig. 55 (we leave the assessment of the factors "Teaching Methods" to the reader for independent calculations).

Rice. 55. Ishikawa diagram with calculated relative weights of factors

Calculate the weighting factors of the Teaching Methods group by yourself, having previously collected expert assessments.

Workshop 5. Construction of Shewhart's map

1. Using Microsoft Excel and OpenOffice.org Calc
to build a Shewhart map

The work in Microsoft Excel and OpenOffice.org Calc for the construction of Shewhart maps is carried out in the same way, with the exception of the peculiarities of the appearance of the Chart Wizard and the names of the necessary functions (Table 12).

Table 12

Some statistical functions in Microsoft Excel and OpenOffice.org Calc

Consider the construction of a Shewhart map in Microsoft Excel using the following example.

The data on the qualitative performance of 7 groups are given (tab. 13)

Table 13

Quality Performance Data

Group	1gr.	2 gr.	3 gr.	4 gr.	5 gr.	6 gr.	7 gr.
High-quality academic performance,%

1. We calculate the arithmetic mean () and standard deviation () according to the initial data (Fig. 56).

Rice. 56. Calculation of the arithmetic mean and standard deviation

2. Create a series for building the line of the average value, for this we multiply the value, as in fig. 57.

Rice. 57. Creating a series of centerline data

3. We calculate the values for the lower (-3) and upper (+3) control boundaries and create rows with these values (Fig. 58).

Rice. 58. Create series of control boundaries

4. Calculate the values for the lower (-2) and upper (+2) warning boundaries and create rows with these values (Fig. 59).

Rice. 59. Generating data series of warning boundaries

5. Having selected the constructed series (Fig. 60), we call the Chart Wizard

Rice. 60. Allocation of data series for building Shewhart's map

Step 1. Choosing a chart type Schedule(fig. 61) .

Rice. 61. The first step of the Diagram Wizard

Step 2. In the next step, the Chart Wizard tab Row displays the layout of the future chart for the previously selected data range. To them by pressing the button Add, add a number of values for quality academic performance (Fig. 62).

Rice. 62. Second step of the Diagram Wizard

Step 3. At this step of the Chart Wizard, you can enter the necessary chart parameters (for example, its name, labels of the X and Y axes, etc.)

Rice. 63. The third step of the Diagram Wizard

Step 4. At step 4 of the Chart Wizard, select the location of the chart.

10. Let's arrange the diagram as follows. Right-click the plot area and select Format Plot Area. In the window that appears, make the fill white.

Right-click on the centerline series in the graph and select Format Data Series from the context menu. Set the parameters as in fig. 64.

Rice. 64. Data series format

Change the appearance of the rest of the data series in the same way so that it looks like in Fig. 65.

Rice. 65. Shewhart map, built in Microsoft Excel

Note that on the graph, the values of quality performance are represented by dots with unconnected segments. This is because the data in our example is independent and unrelated to each other. If we were dealing with the progress of the same group in time, it would be appropriate to leave the segments connecting the points.

As you can see, the qualitative performance in the studied groups varies within the range of ± 2σ and mostly above the middle line. However, the values of qualitative performance in groups 1 and 7 are close to the lower warning limit, the situation is not critical, but perhaps a deeper analysis of the reasons for this situation is needed.

If in the future a similar map is drawn based on the results of the next milestone control, then we consider it important to pay attention to the shift of the middle line up or down, which will indicate a general trend.

Practice 6. Building a Pareto chart

1. Using Microsoft Excel and OpenOffice.org Calc
building a Pareto chart

According to the survey, a table was compiled. 14, reflecting the reasons for low academic performance according to the opinions of respondents.

Table 14

Poll results

In both software tools we are considering, these Pareto charts are built in a similar way, so we will consider the stages of their creation in Microsoft Excel.

1. We place the data on the sheet in Microsoft Excel.

2. Having selected the placed table, select from the menu Data option Sorting…(fig. 66).

Rice. 66. Selecting the Sort option ...

In the window that appears, indicate that we will sort by the number of responses in descending order and click on the button OK(fig. 67).

Rice. 67. Range sorting options

3. Calculate the accrued interest (cumulative interest). To do this, let's calculate the sum of all the answers. Then we calculate the share of answers for the first reason "Discrepancy between the complexity and labor intensity of the discipline in the curriculum" (Fig. 68).

Rice. 68. Calculation of the first value of a series of accrued interest

The formula for the second reason and the following will contain the sum of the shares of the current answers and the previous line (Fig. 69).

Rice. 69. Calculation of the second and subsequent values of a series of accrued interest

Having selected the obtained values, we call the context menu and change the format of the cells to percentage (Fig. 70).

Rice. 70. Changing cell formats

As a result, a number of accrued interest was received.

4. Call the Chart Wizard and build a histogram based on two data series "Number of responses" and "Accumulated percentages" (Fig. 71).

Rice. 71. Histogram by the number of answers and the number of accumulated interest

By clicking on the row of accumulated interest on the histogram, we call the context menu and select the option Data series format.

In the window that appears on the tab Axis note that we will build the series along the auxiliary axis and press OK(fig. 72).

Rice. 72. Adding an auxiliary axis

By clicking again on a number of accumulated interest, we call the context menu and select the option Chart type... In the window that appears, select the "Graph" type and the desired view - "Graph with markers marking data points" (Fig. 73).

Rice. 73. Changing the type of the schedule of a series of accumulated interest

In accordance with the resulting Pareto chart (Fig. 74), the greatest attention should be paid to the first three reasons, since they cause 80% of the problems with academic performance according to the respondents.

Rice. 74. Pareto chart for analyzing the reasons for low academic performance according to survey results