Auxiliar de diagrames - Interval de dades

Opens the Data Ranges dialog where you can edit Data Range and Data Series.

En aquesta pàgina de l'Auxiliar de diagrames podeu seleccionar una font d'interval de dades única. Aquest interval pot estar format per més d'un interval rectangular de cel·les.

Aquest diàleg només està disponible per a diagrames basats en una taula del Calc o del Writer.

Per indicar un interval de dades

1. Seleccioneu l'interval de dades i realitzeu una de les accions següents:

   Introduïu l'interval de dades en el quadre de text.

   In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range.

   An example of external data range would be like 'file:///home/user/Documents/Price list.ods'#$'Information SKU'.H51 as described in Referencing a Cell in Another Sheet.

   In Writer, an example data range would be "Table1.A1:E4".

   En el Calc, feu clic a Selecciona l'interval de dades per minimitzar el diàleg i arrossegueu el cursor per una àrea de cel·les per seleccionar l'interval de dades.

   Si voleu obtenir un interval de dades d'àrees de cel·les múltiples que no siguin contigües, introduïu el primer interval, afegiu manualment un punt i coma al final del quadre de text i introduïu els altres intervals. Utilitzeu un punt i coma com a delimitador entre intervals.

2. Feu clic a una de les opcions per a les sèries de dades en files o en columnes.

3. Comproveu si l'interval de dades té etiquetes a la primera fila, a la primera columna o a tots dos llocs.

Podeu veure l'aspecte final del diagrama a la previsualització.

Data Range

Enter the data range that you want to include in your chart. To minimize this dialog while you select the data range in Calc, click the Select data range button.

Data series in rows

Data series get their data from consecutive rows in the selected range. For scatter charts, the first data series will contain x-values for all series. All other data series are used as y-values, one for each series.

Data series in columns

Data series get their data from consecutive columns in the selected range. For scatter charts, the first data column will contain x-values for all series. All other data columns are used as y-values, one for each series.

First row as label

For data series in columns: The first row in the range is used as names for data series. For data series in rows: The first row in the range is used as categories. The remaining rows comprise the data series. If this check box is not selected, all rows are data series.

First column as label

For data series in columns: The first column in the range is used as names for data series. For data series in rows: The first column in the range is used as categories. The remaining columns comprise the data columns. If this check box is not selected, all columns are data columns.