OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 77)

Placement

Selects the placement of data labels relative to the objects.

Figure 77 on page 83 shows examples of values as text (neither Show value as

number nor Show value as percentage selected) and values as percentages, as well

as when data values are used as substitutes for legends or in conjunction with them.

Trend lines

When you have a scattered grouping of points in a graph, you may want to show the

relationship of the points. A trend line is what you need. Calc has a good selection of

regression types you can use for trend lines: linear, logarithm, exponential, and

power. Choose the type that comes closest to passing through all of the points.

To insert trend lines for all data series, double-click the chart to enter edit mode.

Choose Insert > Trend Lines, then select the type of trend line from None, Linear,

Logarithmic, Exponential, or Power. You can also choose whether to show the

equation for the trend line and the coefficient of determination (R

To insert a trend line for a single data series, first select the data series in the chart,

and then right-click and choose Insert > Trend Line from the context menu. The

dialog for a single trend line is similar to the one below but has a second tab (Line),

where you can choose attributes (style, color, width, and transparency) of the line.

Figure 73: Trend Lines dialog

To delete a single trend line or mean value line, click the line, then press the Del key.

To delete all trend lines, choose Insert > Trend Lines, then select None.

A trend line is shown in the legend automatically.

If you insert a trend line on a chart type that uses categories, such as Line or Column,

then the numbers 1, 2, 3, … are used as x-values to calculate the trend line.

Chapter 3 Creating Charts and Graphs 77

1 2 ... 72 73 74 75 76 77 78 79 80 81 82 ... 433 434

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 77