Mean Value Line.ods
The attached file is set up as a line graph. Column A has 15 Dates; Column B is a set of 12 numbers. The last three dates do not have any numbers in column B. I have set the chart range to be all dates, so the blank numbers are included.
When I delete the last three dates, the mean value line appears when set as a line graph. When I change the chart type to the x-y scatter graph, the mean value line is present regardless of the blank cells.
Another observation, when switching the graph from Line to XY, the dates on the x-axis switch from those shown in the data set to apparent random dates.
To answer my own question that yes “this is me”, but cannot confirm if this is an anomoly or expected behaviour (excluding the fact that it is not necessarily the correct way to plot data).