Apache OpenOffice (AOO) Bugzilla – Issue 29464
XY charts not generated as expected.
Last modified: 2013-02-24 21:19:58 UTC
Attempting to draw a scatter plot for four XY points actually produces something essentially meaningless for three points. I shall attach spreadsheet file "bad chart". I selected the data range A3 to c6, selected insert chart, accepted that the lables were in column 1, and told it that the data points were in rows, not columns. I got a chart with 3 data points, not four, and the data values are not paired by rows. I shall attach a graphic showing the type of result I was trying to achieve, "good chart.jpg" I don't think this is a chart problem. If I cut&paste the chart into writer and look at the data points, the chart is drawn correctly for what it is given. I think the problem is with the wizard that creates the chart from the spreadsheet.
Created attachment 15436 [details] spreadsheet showing four data points and a 3-series chart
Created attachment 15437 [details] graphic showing the sort of thing I was trying to produce
Wrong component, I changed it to Chart and re-assigned it. Frank
Works fine on Win XP Pro 2002 SP1, OOo 1.1.2 Im sorry but I belive you ment to select "Data Series in: Columns" when you created the chart, not "Data Series in: Rows". When i try to create it as rows it comes out like your bad chart and as columns it looks correct. Can you check wether you slected the wrong option by acident or wether it used the wrong type by error. I belive this to be invalid. I'll attach my version of the chart, tell me if this is correct.
Created attachment 16101 [details] Is this what you were trying to achive?
Pretty much it is. But each data pair is a row. Why should I tell it they are in columns? I've backtracked, and found I tried columns too with 1.1.0 and got 8 data points, much as I did with Excel (perhaps because I inculded the first column as labels, but that prevented data pairing) . I've now tried it in 1.1.3 and in 680m41 and it's fine, apart from this naming confusion. Which is probably mine.
Perhaps it is confusing, personally I go by the previews. Always have. M$ Excel seems to act in the same way as OOo for me here.
Cool. I suppose we can close it.
closed