Chart Data Table

Opens the Chart Data Table dialogue box in which you can edit the chart data.

The Chart Data Table dialogue box is not available if you insert a chart that is based on a Calc sheet or on a Writer table.

Note Icon

Some changes will become visible only after you close and reopen the dialogue box.


To access this command...

Choose View - Chart Data Table (Charts)

On Formatting bar, click

Icon

Chart Data


Press Shift+F1 and point to a control to learn more about that control.

To change chart data

When you create a chart that is based on default data, or when you copy a chart into your document, you can open the Chart Data Table dialogue box to enter your own data. The chart responds to the data in a live preview.

Close the Chart Data Table dialogue box to apply all changes to the chart. Choose Edit - Undo to cancel the changes.

  1. Insert or select a chart that is not based on existing cell data.

  2. Choose View - Chart Data Table to open the Chart Data Table dialogue box.

    The data series are organised in columns. The role of the leftmost column is set to categories or data labels respectively. The contents of the leftmost column are always formatted as text. You can insert more text columns to be used as hierarchical labels.

  3. Click a cell in the dialogue box and change the contents. Click another cell to see the changed contents in the preview.

  4. Enter the name of the data series in the text box above the column.

  5. Use the icons above the table to insert or delete rows and columns. For data series with multiple columns, only whole data series can be inserted or deleted.

  6. The order of the data series in the chart is the same as in the data table. Use the Move Series Right icon to switch the current column with its neighbour to the right.

  7. The order of the categories or data points in the chart is the same as in the data table. Use the Move Row Down icon to switch the current row with its neighbour below.