OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 270)

Chapter 4: Spreadsheets in Calc

If the age groups, rather than the towns, should appear on the horizontal axis, tilt the chart.

As long as the chart remains selected, the main toolbar contains a Data in Columns icon.

Click and rotate it with the mouse.

Other changes to the individual elements of the chart are also possible. Either double-click on

the individual parts of the chart or, with the chart selected, choose the individual functions

from the Format menu. For example, double-clicking on the colour preview in the legend

automatically reformats all relevant data points. On the other hand, clicking on the

background in the box of the legend, formats the background to the legend.

If the chart was created from the data of a Calc spreadsheet, clicking on the data series in the

chart becomes highlighted.

Suppose there's an Calc spreadsheet in the background, and now it needs to be

selected for further editing. Open the Show Draw Functions floating toolbar

and select the first tool, the Select arrow. This allows the chart to be selected

by clicking.

In a Calc chart, a data series can be forwards or backwards. A series can be arranged in such

a way that the lowest 3D representations are as far forward as possible and the higher ones

further back. To change the arrangement in the chart, use the appropriate command from the

context menu of a data series or choose Format > Order. The output data in the Calc

spreadsheet will not be rearranged.

Note: When a chart is inserted in a presentation or drawing document with the Insert > Insert Chart floating

toolbar, it is displayed with a set of sample data. To insert a chart in a spreadsheet, highlight the cells in the

spreadsheet whose values should be displayed in the chart.

In Writer documents too, charts can be inserted that are obtained from the data of a Writer table. Where no data

are selected in a OpenOffice.org Writer table, selecting Insert > Object > Chart also inserts a chart containing

sample data in OpenOffice.org Writer.

Values in a chart containing sample data can be changed by double-clicking on the chart and then choosing Edit >

Chart Data. When the values of a chart obtained from selected data are changed, the values in the cells of the table

must be changed. If the chart is in a text document, press (

) to update the chart.

Modification of chart data is also possible if, for example, a chart is copied a chart from a Calc document into a

Writer document and is now double-clicked in the Writer document. Remember, however, only this copy is being

edited and not the original document.

OpenOffice.org User Guide for 2.x 236

1 2 ... 265 266 267 268 269 270 271 272 273 274 275 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 270