Difference between revisions of "Chart2/Axis"
From Apache OpenOffice Wiki
< Chart2
Tonygalmiche (talk | contribs) |
(fixed issue 25706) |
||
(8 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
== Limit the number of axis labels displayed == | == Limit the number of axis labels displayed == | ||
+ | [[Image:Chart2_Axis1.png]] | ||
* 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=58731 | ||
− | == | + | |
− | * | + | |
− | + | ||
+ | == Affect units to the axis == | ||
+ | [[Image:Chart2_Axis5.png]] | ||
+ | * 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 == | ||
+ | [[Image:Chart2_Axis8.png]] | ||
+ | * 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 == | ||
+ | * 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.