Difference between revisions of "Chart2/DataLabels"

Revision as of 17:49, 16 August 2007

In column charts the data labels are so far always plositioned on top of the data point rectangle.
In Excel, it's possible to define different automatic positions:
- 564 = external border
- 514 = internal border
- 427 = centered
- 250 = internal based
covered in http://www.openoffice.org/issues/show_bug.cgi?id=63857

If the automatism for data label positioning does not generate the desired result, it must be possible to adjust the position of each label manually.
covered in http://www.openoffice.org/issues/show_bug.cgi?id=48170

@@ Line 58: / Line 58: @@
 * covered in http://www.openoffice.org/issues/show_bug.cgi?id=27804
-== IMPORTANT: Outliers ==
-Occasionally we have to represent data that contains '''outliers'''. This is currently not easy performed. Consider the following data series: ''1, 2, 3, ..., 9, 10,'' and ''200''.
-Obviously 200 is far beyond the rest of the data. If we plot a bar-graph, the values ''1-9'' will be barely visible (and have almost the same magnitude), while the value 200 will strike out.
-'''Workaround'''
-To solve this issue, we need to be able to split the '''Y-Axis''' into 2 sections:
-* first section could be from 0 to 20
-* then it follows a short empty space (Y axis is discontinuous)
-* and the 2nd Y-axis, which contains values around 200
-e.g.
-   '''Y-axis'''
-     ^         ^
-|         |
-|         |
-|         |
-     /   ''OR''   ...
-     /         |
-  |         |
-  |         |
-  |         |
- a strike
-  through   ''OR''  ...
- the Y-axis
-This way it is possible to display accurately both the outlier (the ''200'' value) as well as the normal data, enhancing therefore the visualisation of all the relevant data.