Apache OpenOffice (AOO) Bugzilla – Issue 11313
Cannot remove tick marks on X axis of line chart and annoying row labels
Last modified: 2013-02-24 21:20:00 UTC
Have one (or more) column of data. Just make sequencial data for test 1 to 1000 in column A. Select all of them, create chart, select line chart, and use defaults. The chart created will display 1000 row label (row1-row1000). This is useless (a simple row number like the y axis would be more appropriate). So I chose to unselect show labels to remove the umwanted row labels. This solves the annoying part, but I cannot find any way to remove all the tick marks (1000 of them on X axis) making a very ugly thick axis. Another problem with the row labels is that it really slows down the chart creating process. Try creating the line chart with 2000 data . Takes 15 seconds just for simple data (1 to 2000 sequential ). And this is on a very fast machine: Athlon XP 2100+ W2KSP3 512MB of DDR memory. And takes about the same time each time the axis property is modified. It only takes 1-2 second if the show labels is unselected. So why not make the default as unselected.
See: http://graphics.openoffice.org/chart/featurewishes.html So i close it.
Invalid, because is on the Featurelist.
closed
I believe the issue is not in the feature list. I have rechecked them. If I understand you correctly, these 2 points quoted is what you refer to. Embedding in Spreadsheet Smart detection of labels. If data for a chart is structured like this: | A B C D --+-------------------- 1 | X Y Z 2 | 1999 123 234 345 3 | 2000 876 765 654 4 | 2001 665 443 221 detect the numbers in the first column as labels because the cell A1 is empty if a column or row (especially the first one of a range) is formatted with a Heading style use it for labels Now that does not resolve the fact any of the 2 item I stated in the problem. 1. It does not provide a way to remove the tick marks. 2. it is not related to the second problem: this problem occurs if we would like to use the row index as the X axis. The feature list uses the first row for the X axis. the linear data I mentioned is just an example (an easy to generate data), it is the Y axis data, not the X axis data. What really trouble us as users is the fact that it actually treated the row indexes as labels instead of simple number. This slows down the process to an unacceptable response time. To make it clearer this is an example data table: | A -+------- 1| 23 2| 50 3| 30 4| 40 etc. now CHART will make a line chart but put row 1, row 2, row3, row 4, etc on the X-axis. This is not really a problem if we only have 4 rows but it is a problem in real-world data ( a few hundreds to a few thousands). I believe that this slows down the process because it treats the row indices as label instead of numbers. Because of that it also created ticks for each of them, and it created problem no. 1 because they cannot be removed. I am afraid that the feature list is actually troublesome and not required. We can simply uses X-Y chart and it would have done that.
I take it again
Basicly i agree with you, but it is on the featurelist (Last point under Topic Core, in green) So it will be part of the new chart. Under these circumstances i only can close the issue. FYI: To close this issue i must set this issue to a resolution that match. The only one possible is invalid.
*** Issue 35335 has been marked as a duplicate of this issue. ***