Apache OpenOffice (AOO) Bugzilla – Issue 114434
XY (Scatter) Chart Labels common for different Data Series
Last modified: 2014-03-26 09:09:26 UTC
There is a problem with setting up an XY (Scatter) chart with point labels. Specifically, when using three columns of data, one for x values, one for y values, and one for point labels, the chart can be set up and labels depicted properly only if there is ONLY one series set up in the chart. If Column A is point labels, column B is x values, and column C is y values, and the data is represented in 15 rows then the chart will properly show the points at the correct xy coordinates and with the point labels from column A for all fifteen data points as long as they are all in one "Data series" in the chart. If rows 1 through 5 are one series, rows 6 through 10 are a second series, and rows 11 through 15 are a third series, each of the series can have separate "X- Values" Data ranges, "Y-Value" Data ranges, and a separate "Range for Name", but cannot have a separate corresponding range for "Data labels". The data field noted as "Data labels" in the "Data Ranges" dialog box should vary with the series selected in the "Data series" box, but remains constant while all the other data fields do change with the series selection. The problem was observed running under the Microsoft XP operating system and the Windows 7 operating system. It was also observed in OOo 3.2.1 (OOo320m18) and OOo 3.3Beta1.
Created attachment 81932 [details] example spreadsheet
Confirmed with AOO410m1(Build:9750) - Rev. 1537113 Rev.1537113 Win 7
Version has been modified erroneous, so back to most early version I created an enhanced sample document from <<2013-11-15 12:23 CET, Edwin Sharp>> Showing a little more descriptive why this limitation is annoying: The Y-data-range is divided in 3 sub ranges C2:C6, C7:C11, C12:C16. That allows to use different symbols for each of three data ranges But that breaks labeling (Labels for symbols starts newly with "la01" for each data range instead of labeling continuously la01 ... la15 The additional chart shows correct labeling, but there is no way to get different symbols within the data la01 ... la15 The reason is that in 'Data Ranges -> Data Series' the range shown in 'Data Labels' is common for all data series (y, y, y): When you check for first "y": shows "$Sheet1.$A$2:$A$16" When you check for second "y": shows "$Sheet1.$A$2:$A$16" Try to change to "$Sheet1.$A$7:$A$11" appropriate for this data series the modification will be taken for all 3 data series The problem is not a special XY Chart problem, the limitation with the common Data Labels exists for all chart types. But for XY chart I see the most obvious application where this limitation is a problem.
Created attachment 82977 [details] Enhanced Sample document See comment above how to use
The compromise to use "category" for data labels has been introduced with the new chart module (cws:chart2, around 2006). There exist two workarounds: (1) Write the data series into different columns, using the same range for labels and x-values, and leave the not needed y-values empty. (2) Make one data series, and format the single data points, not the whole data series.
Created attachment 82979 [details] example with added workarounds