Apache OpenOffice (AOO) Bugzilla – Issue 101936
Scatter Plot broken - Selecting first Row as Label breaks plot
Last modified: 2013-02-24 21:21:43 UTC
This error is reproducible, though not always. I do not know a definite method to reproduce it, though I will attach a spreadsheet that shows the error. Generate a Line Plot (Points and Lines): - first row is a numerical label (e.g. years) - NO Label for the rows [i.e. first column is not a label, but data, too] Select the data, draw a Line plot (Points and Lines) with data series in rows. By default, first row is NOT ticked as column label, BUT de facto is used as a column label (this would be correct). However, manually ticking the option First Row as Label, breaks completely the plot. I could reproduce this error, but unfortunately it is hard to track and might fail to show up even with the same data set. I am using OOo-dev m47 on Win2k.
Created attachment 62274 [details] Spreadsheet showing broken PLOT
I noticed now, that I mis-clicked on Scatter Plot (XY), instead of Line Plot. It is still broken though, with the first row being dropped instead of set as label, and the second row being used instead as label, yielding a very strange plot.
For an XY-Chart the "label" (in your case the first row) is not the text at the x-axis tacks. But it is a text assigned to the data points which you can enable in Insert > Data labels > Show Category. In XY-Charts the x-axis is always a value-axis. To get a proper legend, you have to include the column A in your data range and enable "First row as label". Perhaps http://www.ooowiki.de/DiagrammMitLinien might help you to distinguish the properties of "XY-Chart" and "Line Chart". (It is in German, but you can use an automatic translation for example with Google, then see section 'data point labeling' German: Datenpunktbeschriftung.)
It doesn't work for me at all. Actually, the first row contains various years. However, this row has disappeared from the plot. Instead of using this row as a label, Calc uses the second row as label when the Label option is ticked. This is the actual error. It should have ticked by default the Label option, and use the Years-row as a label, NOT the second row.
Again: In an XY-Chart the term "label" does _not_ mean the texts on the x-axis, but in XY-Chart "label" is an additional information, which can be shown near to the data points. Therefore you must not check "first row as label" if this row contains the values, which you want to see at the x-axis. You should discuss the "label"-problem in a forum or mailing list.
No bug.
As regina has written, your issue is not a bug. So i will close it. For further information pls use a forum or a mailing list.