Difference between revisions of "Chart2/Axis"
(removed already implemented features from the list of missing features) |
(→Inverse axis position: this is implemented now -> remove from the list of open issues) |
||
| Line 6: | Line 6: | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
== Affect units to the axis == | == Affect units to the axis == | ||
Revision as of 16:02, 10 February 2009
Contents
- 1 Limit the number of axis labels displayed
- 2 Affect units to the axis
- 3 Modify the scale of X axis also when it's not an XY chart
- 4 Axes labels customizable
- 5 Units of axes properties (numbers, hours, days, month
- 6 Ability to fix the maximum and minimum property of axes from a spreadsheet cell
- 7 Allow to change spacing between axes and axes labels
- 8 Outliers: Break Axis
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
Modify the scale of X axis also when it's not an XY chart
- In this example, scale begins on the 1/1 and ends the 3/1 while data begin the 2/1 and end on the 4/1.
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
Units of axes properties (numbers, hours, days, month
- The dialog that allows to modify axes properties doesn't indicates units (hours, days, weeks, month...) to adjust the scale (minimum, maximum, primary and secondary intervals)
an axes formatted to date and where the primary interval settings are less than 24 hours will be displayed as “double” format and not as hours.
- It's not possible to set a maximum date or a minimum date but only a number representing date in a numerical format.
- If axes are in date format, it's not possible to settle an interval every 1st of each month.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=25706
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.
