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.
|Use the Chart Wizard - Data Series page if you need more control over the data ranges.|
Choose 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.
Press Shift+F1 and point to a control to learn more about that control.
To specify a data range
- Select the data range. Do one of the following:
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.
- Click one of the options for data series in rows or in columns.
- 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.