Opens the Data Table dialog where you can edit the chart data.
The Data Table dialogue is not available if you insert a chart that is based on a Calc sheet or on a Writer table.
Some changes will become visible only after you close and reopen the dialogue.
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 Data Table dialogue to enter your own data. The chart responds to the data in a live preview.
Close the Chart Data dialogue to apply all changes to the chart. Choose Edit - Undo to cancel the changes.
Insert or select a chart that is not based on existing cell data.
Choose View - Chart Data Table to open the Data Table dialogue.
The data series are organised in columns. The role of the left most column is set to categories or data labels respectively. The contents of the left most column are always formatted as text. You can insert more text columns to be used as hierarchical labels.
Click a cell in the dialogue and change the contents. Click another cell to see the changed contents in the preview.
Enter the name of the data series in the text box above the column.
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.
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 on the right.
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.