Chart Wizard - Data Range

On this page of the Chart Wizard you can select one single source of data range. This range may consist of more than one rectangular range of cells.

Konsileta bildsimbolo

Use the Chart Wizard - Data Series page if you need more control over the data ranges.

Por atingi ĉi tiun komandon...

Choose Insert - Chart...


Insert Chart

Double-click a chart, then choose Format - Data Ranges

This dialog is only available for charts based on a Calc or Writer table.

Premu je Maj+F1 kaj indiku regilon por lerni pli pri tiu regilo.

To specify a data range

  1. Elektu viajn preferojn por datumetikedado de la jeno:

    Enter the data range in the text box.

    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. In Writer, an example data range would be "Table1.A1:E4".

    In Calc, click Select data range to minimize the dialog, then drag over a cell area to select the data range.

    If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.

  2. Click one of the options for data series in rows or in columns.

  3. Check whether the data range has labels in the first row or in the first column or both.

In the preview you can see how the final chart will look.

Bonvolu subteni nin!