Difference between revisions of "Chart2/Axis"
From Apache OpenOffice Wiki
< Chart2
Tonygalmiche (talk | contribs) |
(fixed issue 25706) |
||
(6 intermediate revisions by 4 users not shown) | |||
Line 3: | Line 3: | ||
* 1 over 2, 1 over 3,... | * 1 over 2, 1 over 3,... | ||
* Displaying the labels is automatic but it doesn't always meet the needs. | * Displaying the labels is automatic but it doesn't always meet the needs. | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=58731 |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
Line 28: | Line 13: | ||
* Kilo, Mega,... | * Kilo, Mega,... | ||
* This example displays units in Thousands. | * This example displays units in Thousands. | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=29918 |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Axes labels customizable == | == Axes labels customizable == | ||
Line 48: | Line 20: | ||
* In this example, date format displayed differently from the data range. March label text is manually modified. | * 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. | * 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= | + | * 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 == | ||
+ | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64704 | ||
− | |||
− | |||
+ | == Allow to change spacing between axes and axes labels == | ||
+ | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64705 | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | == 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. | |
− | + | [[Category:Chart2]] | |
− | |||
− | |||
− |
Latest revision as of 15:16, 15 December 2010
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.