Sometimes it becomes necessary to edit chart series data after the chart was created, e.g. because there are outliers one does not want to show or the start or end should be removed etc.
PLEASE NOTE THAT CHANGING THE CHART DATA DOES NOT CHANGE THE UNDERLYING TABLE DATA!
This can be achieved by selecting the relevant series in the Chart Properties dialog and selecting the Edit Data button. A new window with a grid with three columns will pop up showing the X, Y and Text fields of the underlying data. X and Y represent the data on the relevant axes and the Text field is an additional identifier, mostly the Y value which can be shown in the Marks of points in the series.
If the X axis is a date/time axis then the data should be entered/corrected in the same format as show, otherwise errors will occur when saving the data back to the chart (OK button) resulting in skipped data in the chart. In order to edit data the grid needs to be double-clicked and then the relevant cell to be edited selected or alternatively F2 can be hit and then the cell selected. When moving to a new row the data is automatically save in the previous row and the grid returns into non-editing mode. This is to prevent unintended editing.
Right-clicking the grid will bring up a popup menu through which a row can be deleted (Crtl-Del on a row has the same result) or this Help activated.