From The Document Foundation Wiki
How to edit the data range of a chart
- Enter the chart with a double click.
- Right-click on the chart (green handles appear) and choose Data range in the contextual menu.
- On the Data Range tab, modify the range, or in the tab Data Series, add or delete the series that you want.