Difference between revisions of "Chart2/Axis"
From Apache OpenOffice Wiki
< Chart2
(Added Outliers: Axis Break) |
(fixed issue 25706) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| Line 29: | Line 14: | ||
* This example displays units in Thousands. | * This example displays units in Thousands. | ||
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=29918 | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=29918 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Axes labels customizable == | == Axes labels customizable == | ||
| Line 48: | Line 21: | ||
* In Excel 2000, it's not possible to modify text and label format individually. | * In Excel 2000, it's not possible to modify text and label format individually. | ||
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64703 | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64703 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Ability to fix the maximum and minimum property of axes from a spreadsheet cell == | == Ability to fix the maximum and minimum property of axes from a spreadsheet cell == | ||
| Line 69: | Line 29: | ||
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64705 | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64705 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Outliers: Break Axis == | == Outliers: Break Axis == | ||
| Line 112: | Line 61: | ||
This way it is possible to display accurately both the outliers (the ''200'' value) as well as the normal data, enhancing therefore the visualisation of all the relevant data. | This way it is possible to display accurately both the outliers (the ''200'' value) as well as the normal data, enhancing therefore the visualisation of all the relevant data. | ||
| + | [[Category:Chart2]] | ||
Latest revision as of 15:16, 15 December 2010
Contents
Limit the number of axis labels displayed
- 1 over 2, 1 over 3,...
- Displaying the labels is automatic but it doesn't always meet the needs.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=58731
Affect units to the axis
- Hundreds, Thousands, Millions,...
- Kilo, Mega,...
- This example displays units in Thousands.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=29918
Axes labels customizable
- One can choose the label text format and number format regardless the data source range.
- In this example, date format displayed differently from the data range. March label text is manually modified.
- In Excel 2000, it's not possible to modify text and label format individually.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=64703
Ability to fix the maximum and minimum property of axes from a spreadsheet cell
Allow to change spacing between axes and axes labels
Outliers: Break Axis
Occasionally one has to picture 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-10 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 outliers (the 200 value) as well as the normal data, enhancing therefore the visualisation of all the relevant data.
