https://bugs.documentfoundation.org/show_bug.cgi?id=163715
Bug ID: 163715
Summary: X-Y Scattergraph "Data series in rows" fails to add
correct error bars from feild
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: [email protected]
Reporter: [email protected]
Created attachment 197336
--> https://bugs.documentfoundation.org/attachment.cgi?id=197336&action=edit
A demo file to test the issue with, including a "correct" answer for comparison
If one has one has an X-Y scatter graph and needs to change the data source
from the default “Data Series in rows” to “Data Series in columns” and one is
supplying calculated Y-error bars, then using (Menu Bar) → Insert → Y-Error
Bars
and selecting the appropriate field for the error bar values creates a graph
with incorrect error bars. The right values might be present but then they are
assigned to the wrong data points in the graph. I haven't done any tests to
confirm, but my untested hypothesis is that it seems to only add in the Error
bar data in rows and thus is in transpose relative to the data series it is
sampling which means the same dynamic source tables I use to calculate the data
for these graphs and the error bar layout cannot be used without transposing
one of them and generally making the situation so complicated I have never
gotten it to work correctly.
I have gotten others to confirm this when initially asking for help about this
(assuming I was just doing it wrong) on the "ask Libre" site. For the
potentially relevant discussion see here:
https://ask.libreoffice.org/t/complex-x-y-scatter-graph-error-bar-challenges/113101
One of the people there LeroyG, confirmed the issue, but said it did work
properly in their hands, if and only if, they added only a single row of error
bar data. Multiple rows caused mis-assignment of the error bars to their
corresponding data or whatever is going on here that produces the wrong error
bars.
I have no idea if this is also true of X-Error bars, I haven't tried it. But
assuming they rely on a good deal of the same underlying code there is likely
the same issue there too.
I have attached a useful test file as it has the "right answer" as well as the
whole graph minus error bars just below it so that one can assign error bars to
it to see the results. The "right answer" can be obtained only (at least by my
ability to tell) by laboriously manually selecting each and every data series
and manually assigning it a single row of Y-error bars. Anything else I can
figure out how to do produces errors with the error bars. Below are
instructions for the file:
“Errorbar_graph_example.ods” Here is the description so people can test things:
-one tab “Example Processed”
-Table “Graph values” at top left (start at cell B2) has the actual values for
the data series of the graph. I have made them static for simplifying this
example file but they used to be dynamic based on processing between 3 much
larger tables.
-Table “Y-error bars” to the right of the above (start at cell R2) has the
values for the Y-error bars to be added to the graph. These are a single set of
errors, i.e. “positive values = negative values” which is how they should be
added to the graph. This table has also been made static for simplifying this
example file but was formerly dependent on number of larger tables.
-Graph “How Graph Should look (manually “click” added Y-error bars)” starts at
Cell B21. This graph and its error bars are correct because each data series
was individually selected and the error bar series was manually added to each
one.
-Graph “Try Adding the error bars in a single step to this graph” starts at
Cell B57. This graph is the example graph. It has the structure, source data,
scale, etc… of the graph above, but no error bars have been added to this
graph. How does one add error bars to this graph in a single step as opposed to
laboriously clicking on each of the series zooming in and struggling to with
the more difficult to reach ones?
I can select the “Try Adding the error bars in a single step to this graph”
graph. Edit it. Do Menu->Insert->Y Error Bars… and select the values on the
“Y-error bars” table. This adds error bars to this graph BUT THEY ARE WRONG!!!.
One can check this by looking at the “How Graph Should look (manually “click”
added Y-error bars)” and see that these may be the right values but they have
been added to the wrong points on the graph. THE EASIEST BY EYE QUICK CHECK
FOR CORRECT ERROR BARS is the nice flat “Media and Cells” data series has all
the same sized error bars as one can see both in the table and the "correct"
example graph. If one adds error bars to the experiment graph and the “Media
and Cells” data series ends up with error bars that are not all the same size,
then something is wrong (as it usually is every time I or others do this
without manually adding Y-error bars for each data series separately.)
--
You are receiving this mail because:
You are the assignee for the bug.
