Issue 114434 - XY (Scatter) Chart Labels common for different Data Series
Summary: XY (Scatter) Chart Labels common for different Data Series
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-09-10 07:10 UTC by tdwomack
Modified: 2014-03-26 09:09 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

example spreadsheet (16.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-15 11:23 UTC, Edwin Sharp
no flags Details
Enhanced Sample document (25.34 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2014-03-26 06:17 UTC, Rainer Bielefeld
no flags Details
example with added workarounds (39.47 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2014-03-26 09:09 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tdwomack 2010-09-10 07:10:17 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 

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.
Comment 1 Edwin Sharp 2013-11-15 11:23:21 UTC
Created attachment 81932 [details]
example spreadsheet
Comment 2 Edwin Sharp 2013-11-15 11:24:13 UTC
Confirmed with

AOO410m1(Build:9750)  -  Rev. 1537113
Win 7
Comment 3 Rainer Bielefeld 2014-03-26 06:13:49 UTC
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.
Comment 4 Rainer Bielefeld 2014-03-26 06:17:11 UTC
Created attachment 82977 [details]
Enhanced Sample document

See comment above how to use
Comment 5 Regina Henschel 2014-03-26 08:32:42 UTC
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.
Comment 6 Regina Henschel 2014-03-26 09:09:26 UTC
Created attachment 82979 [details]
example with added workarounds