OpenOffice.org OpenOffice - 3.0 User's Guide download pdf (Page 167)

or any data which matches two series of numeric data. In contrast to

line charts, the x-axis are the left to right labels which usually

indicate a time series.

Net charts

net chart

is similar to polar or radar graphs. They are useful for

comparing data that are not time series, but show different

circumstances, such as variables in a scientific experiment or

direction. The poles of the net chart are the y-axes of other charts.

Generally, between three and eight axes are best; any more and this

type of chart becomes confusing.

Stock charts

stock chart

is a specialized column graph specifically for stocks

and shares. You can choose traditional lines, candlestick, and two-

column type charts. The data required for these charts is quite

specialized, with series for opening price, closing price, and high

and low prices. Of course the x-axis represents a time series.

Column and line charts

column and line chart

is a combination of two other chart types. It

is useful for combining two distinct but related data series, for

example sales over time (column) and the profit margin trends (line).

Entering chart data

Opening a chart data window

1) If the chart is not already in edit mode (with a gray border),

double-click it. The main toolbar now shows tools specifically for

charts. (If the main toolbar is not showing, select View >

Toolbars > Main Toolbar.)

2) Click the Chart Data icon or select View > Chart Data

Table, or right-click on the chart and choose Chart Data Table.

The Data Table dialog box (Figure 122) appears.

Tip

If you drag the Data Table dialog box so that your chart is

visible, you can then immediately see the results of each change

after clicking in a different cell.

Chapter 7 Inserting Spreadsheets, Charts, and Other Objects 167

1 2 ... 162 163 164 165 166 167 168 169 170 171 172 ... 274 275

No comments

OpenOffice.org OpenOffice - 3.0 User's Guide Page 167