Apache OpenOffice (AOO) Bugzilla – Issue 6988
graphics with multiple data ranges doesn't behave as expected
Last modified: 2013-02-24 21:21:56 UTC
I am not sure if this is a bug or is a "feature", really ! If is a "feature", is unusual and needs to be highlighted somewhere. Anyway: Two data sets: AÂ Â Â Â Â Â BÂ Â Â Â Â Â Â Â Â Â Â Â Â Â CÂ Â Â Â Â Â Â Â Â Â Â Â Â Â D XÂ Â Â Â Â Â T1Â Â Â Â Â Â Â Â Â Â Â Â Â T2Â Â Â Â Â Â Â Â Â Â Â Â Â T3 1Â Â Â Â Â Â 20Â Â Â Â Â Â Â Â Â Â Â Â Â 25Â Â Â Â Â Â Â Â Â Â Â Â Â 30 5Â Â Â Â Â Â 30Â Â Â Â Â Â Â Â Â Â Â Â Â 35Â Â Â Â Â Â Â Â Â Â Â Â Â 40 10Â Â Â Â Â 40Â Â Â Â Â Â Â Â Â Â Â Â Â 45Â Â Â Â Â Â Â Â Â Â Â Â Â 50 20Â Â Â Â Â 50Â Â Â Â Â Â Â Â Â Â Â Â Â 55Â Â Â Â Â Â Â Â Â Â Â Â Â 60 30Â Â Â Â Â 55Â Â Â Â Â Â Â Â Â Â Â Â Â 60Â Â Â Â Â Â Â Â Â Â Â Â Â 65 40Â Â Â Â Â 60Â Â Â Â Â Â Â Â Â Â Â Â Â 65Â Â Â Â Â Â Â Â Â Â Â Â Â 70 50Â Â Â Â Â 65Â Â Â Â Â Â Â Â Â Â Â Â Â 70Â Â Â Â Â Â Â Â Â Â Â Â Â 75 and AÂ Â Â Â Â Â Â B XÂ Â Â Â Â Â T (float) 3Â Â Â Â Â Â 27 7Â Â Â Â Â Â 36 11Â Â Â Â Â 42 14Â Â Â Â Â 48 20Â Â Â Â Â 56 34Â Â Â Â Â 65 where A, B, C are the built-in columns names in the sheet, and X, T1, T2, etc are user data labels. To draw a XY graphic from theses data sets, a user will choose a data range like this: $set1.$A$1:$D$8;$set2.$A$1:$B$7 OOo will try to merge both columns Bs in a single column, sorting the data in column A, but the user expected a fourth curve, as in MS Excell. (Don't blame me, I warned you that I am not sure if this is a bug - this is the natural way the people "think" and charts imported from a MS Excell like this are drawn in the wrong way) If the data set 2 is placed with the data in column B in another unused column with respect to data set 1 ( for example, column E), the data range: $set1.$A$1:$D$8;$set2.$A$1:$E$7 will draw the graphic as expected (4 curves). I think this must be a feature, not a bug, but how to handle MSExcell drawings like this ?
Hi Miguel, please use XY chart(Autoformat chart, second dialog, second row, second item). Best regads, Peter
Sorry, I have to close this as invalid. Peter
closed
Actually, I'd like to reopen this. It is valid. I was trying to create a chart from some data (various elements, their atomic masses, their calculated Debye temperatures, and their experimental Debye temperatures; 4 columns including the leading point label). Further complicating things was the fact that I had 3 groups of elements (since their actual Debye temperatures were dependent upon other factors than just the atomic mass, with the 3 groups being similar within the group, thus being a group). Anyhow, the data was laid out thus: Material | Mass | CDT | RDT Li 1 3 7 Na 2 4 8 K 3 5 9 C 4 6 10 Si 5 7 11 Sn 6 8 12 Cu 7 9 13 Ag 8 10 14 Au 9 11 15 [numbers are made up; elements are from memory; I can post the actual .sxc if you want] I had to create 3 graphs, one for each grouping of elements, with two data series (calculated and real Debye temperatures). This were xy plots, connected with lines. Ideally, I would have liked to have created one graph of 6 series, making color and/or symbols provide the group links bewteen actual and predicted values. Unfortunately, try as I might, it wouldn't do it. I tried selecting the regions, but, as the person who originally posted this said, it collected the 3 groups into 1, so I had 2 "series" again (the 3 groups were merged together, and the calculated and predicted values of the one meta-group were the 2 series)! Recommendation: either augment the syntax to allow for multiple regions to be counted as separate regions (e.g. a comma instead of semicolon?) or, better, either have multiple Range: textboxes or have a checkbox to say that non-contiguous regions shouldn't be combined into one meta-region.