Difference between revisions of "Chart2/DataLabels"
From Apache OpenOffice Wiki
< Chart2
Tonygalmiche (Talk | contribs) |
m (→IMPORTANT: Outliers: Improve content) |
||
| Line 61: | Line 61: | ||
== IMPORTANT: Outliers == | == 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, and 200''. | + | 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. | 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. | ||
| Line 73: | Line 73: | ||
e.g. | e.g. | ||
| − | Y-axis | + | '''Y-axis''' |
| − | ^ | + | |
| − | 210 | | + | ^ ^ |
| − | 200 | | + | 210 | | |
| − | 190 | | + | 200 | | |
| − | + | 190 | | | |
| − | + | / ''OR'' ... | |
| − | + | / | | |
| − | 20 | | + | 20 | | |
| − | 10 | | + | 10 | | |
| − | 0 | | + | 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. | |
| − | This way | + | |
Revision as of 17:44, 16 August 2007
This list is based primarily on the List of wished enhancements for Charts.
Contents
- 1 Add colors at the background and borderline
- 2 Customize automatic positions of datalabels
- 3 Free positioning of data labels
- 4 The data label number formatting is the same as the axis number formating
- 5 Rotate the labels
- 6 Rotate labels like a clock
- 7 Manually modify the text of a label
- 8 IMPORTANT: Outliers
Add colors at the background and borderline
- Of the labels to ease the readability.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=64700
Customize automatic positions of datalabels
- 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
- 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
The data label number formatting is the same as the axis number formating
Rotate the labels
- 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
Manually modify the text of a label
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.
