I have a set of numbers, each of which is associated with a date. I want a line chart that shows the numbers with the actual dates as labels of the x-axis. Instead, Calc uses arbitrary (?) but equally spaced dates as labels which means that no number is labelled correctly in the chart. For example, I have (using British date format dd/mm/yy)
01/12/16 121
08/12/16 133
23/12/16 121
30/12/16 114
06/01/17 123
20/01/17 134
03/02/17 109
24/02/17 115
03/03/17 107
but the labels used are 26/11/16, 16/12/16, 05/01/17, 25/01/17, 14/02/17, 06/03/17 and 26/03/17. I want the dates in the data to be used as labels, even thought they are not ecenyly spaced. How? Please.