Ask Your Question

Mean Value Line Not Shown on Line Graph [closed]

asked 2014-11-29 23:36:17 +0100

Rugslug gravatar image

updated 2015-08-29 15:17:58 +0100

Alex Kemp gravatar image

I've inserted a Trend Line and a Mean Value Line on an X-Y Scatter graph without a problem. When I create/switch the chart to a Line graph, the Mean Value Line is not shown, although it shows up in the legend and it can be formatted as if it were there.

Is this an anomoly? Is it me? Can anyone duplicate this discrepancy (to confirm or rule out me)?

X-Y Scatter Graph

Line Graph

Windows 7 / LibreOffice and 4.2.6 Portable

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 17:55:37.784920


rautamiekka gravatar imagerautamiekka ( 2014-11-29 23:39:23 +0100 )edit

Funny you would mention that. When I attempt to edit a chart in 4.4.0 Beta, LO crashes (for now I assume this is because it is under development -- not a complaint! Just an observation). That being said, the chart still does not show the mean value line.

Rugslug gravatar imageRugslug ( 2014-11-29 23:42:45 +0100 )edit

No good, at all.

rautamiekka gravatar imagerautamiekka ( 2014-11-29 23:46:49 +0100 )edit

In v on XP I observe no problems

ROSt52 gravatar imageROSt52 ( 2014-11-30 10:20:00 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-11-30 12:24:18 +0100

Rugslug gravatar image

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).

edit flag offensive delete link more

Question Tools


Asked: 2014-11-29 23:36:17 +0100

Seen: 923 times

Last updated: Nov 30 '14