Difference between revisions of "Chart2/DataLabels"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (IMPORTANT: Outliers: Improve content)
 
(4 intermediate revisions by 2 users not shown)
Line 8: Line 8:
 
* Of the labels to ease the readability.
 
* Of the labels to ease the readability.
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64700
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64700
 
 
== Customize automatic positions of datalabels ==
 
 
[[Image:Chart2_DataLabel2.png]]
 
 
* 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
 
 
  
 
== Free positioning of data labels ==
 
== Free positioning of data labels ==
Line 29: Line 15:
 
* 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.
 
* 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
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=48170
 
 
== The data label number formatting is the same as the axis number formating ==
 
 
[[Image:Chart2_DataLabel4.png]]
 
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=37792
 
 
 
== Rotate the labels ==
 
 
[[Image:Chart2_DataLabel5.png]]
 
 
* In numerous cases, it could enhance the graph readability.
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=24203
 
 
 
== Rotate labels like a clock ==
 
 
[[Image:Chart2_DataLabel6.png]]
 
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64701
 
  
  
Line 58: Line 22:
  
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=27804
 
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=27804
 
+
[[Category:Chart2]]
== 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'''
+
+
    ^        ^
+
210 |        |
+
200 |        |
+
190 |        |
+
    /  ''OR''  ...
+
    /        |
+
20  |        |
+
10  |        |
+
  0  |        |
+
+
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.
+

Latest revision as of 09:21, 25 November 2009

This list is based primarily on the List of wished enhancements for Charts.


Add colors at the background and borderline

Chart2 DataLabel1.png

Free positioning of data labels

Chart2 DataLabel3.png


Manually modify the text of a label

Chart2 DataLabel7.png

Personal tools