We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How can I properly display standard deviation on a calc chart? [closed]

asked 2015-06-29 21:34:36 +0200

tox82 gravatar image

I am a total newbie with this kind of operations, but I have a calc sheet with four values and I want to create a chart out of those values, showing two (indipendent) average values and their standard deviations. This is the data that I'm using.

  avg ratio 1/2                 avg ratio 2/1
       0.72                          1.40
standard deviation            standard deviation   
       0.67                          2.24

I have created a bar chart by selecting the first two rows, and it just worked.

Then I have tried to add an "error bar Y", selected standard deviation... but I can't set the values, so this is probably not the correct choice.

So I have clicked on the first bar, selected "data area", then specified the value for the first bar (A4) and the "same value for both" checkbox... it seemed to work but... if I select the second bar the deviation disappears.

Lastly, if I try to do the same directly on the second bar, the standard deviation line goes outside of the chart's margin, and I can't see its boundaries.

How can I properly create this kind of charts?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-22 20:53:20.738162


A comment on this: I found it hard to spot where to link actual cell (data range) for error bars. I found that you have to select the series you're interested in, then right-click and select 'format error bars'. Then on the 'Y Error Bars' tab, there is a place to select a cell range for the + and - (or both the same) error bar data ranges. (It is sometimes hard to use the mouse to select specific data series, especially when there are many series on a figure; there should me a mouse way too)

jdpipe gravatar imagejdpipe ( 2016-08-03 09:47:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-07-03 18:29:32 +0200

tox82 gravatar image

Looks like there is a bug in Libreoffice on Ubuntu 15.04. If I try to do the same with LibreOffice 4.2.x it seems to be correctly working.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-06-29 21:34:36 +0200

Seen: 4,446 times

Last updated: Jul 03 '15