Apache OpenOffice (AOO) Bugzilla – Issue 4770
offer a vertical x axis and horizontal value axis also for line charts (not only for bar charts) (allow swapping axes)
Last modified: 2013-09-25 20:41:54 UTC
It would be very nice, if you could build in this feature in a future release. By now usage is limited because it is only possible to draw data-rows which have common x-values. It is not possible to draw-rows data with common y-values.
Hi Falko, it seems to be one for you. Frank
*** Issue 5894 has been marked as a duplicate of this issue. ***
XY charts act unpredictable - the order of axis doesn't depend on the order of the selected columns in the selection range. For example, $Sheet1.$B$4:$B$131;$Sheet1.$E$4:$E$131 $Sheet1.$E$4:$E$131;$Sheet1.$B$4:$B$131 produce the same result, which depends only on some inner OO thoughts - the first column may be X just as the second one - it depends on OO. In M$ Exel it's possible to change the selections of a XY chart axes independently with the special input fields at a selection dialog window.
Re-assigned to Matthias Müller-Prove for further evaluation.
to Bettina, our central dispatcher for RFEs
Reassigned to Björn.
->IHA: Sending you these issues so that all unconfirmed enhancements and features are at one place.
Maybe add the possibility to choose the X and Y axis seperatly, and maybe add multiple x,y axis (in excel you can "Add" more x,y,axis to the chart and like compine multiple charts).
As I understood this feature request there should be an additional chart type like the xy-chart type only having the axis at swapped positions. (Thus having the same difference as between column and bar chart ). I like the idea of offering this new chart type but I am not convinced of the importance of this feature. So I set a lower Prio.
Issue 28503 does amoung others request the vertical axis to be a category axis. This indicates that swapping the positions of x and y axis is of interest for more charttypes than xy. It would make sense also for area, line and column-and-line charts. So I changed the summary to be not to specialized.
The current 2.0.1 and m156 cannot show two XY charts at the same time: say A vs D and D vs A. In the both cases OO draws the first sequence regardless the range: The first chart is $Sheet1.$D$4:$D$259;$Sheet1.$F$4:$F$259 The second chart is $Sheet1.$F$4:$F$259;$Sheet1.$D$4:$D$259 The result is 2 same charts. It can be solved by additional column, but it is a bug definetely.
Hi bigserpent, I checked the m156 and cannot find a problem with two xy charts at the same time. What you describe is an independent problem I think. The chart does not recognize the order in which you give the ranges to it. As far as I could see this was never different from the current behaviour, or?
*** Issue 62069 has been marked as a duplicate of this issue. ***
*** Issue 75725 has been marked as a duplicate of this issue. ***
Changed summary in hope to make this issue easier to find. Adjusted Prio regarding votes and duplicates.
OOo lacks currently the ability to draw *Dot Plots*, which makes professionally looking graphs more difficult to create. A *Dot Plot* is a superior alternative to the *Bar Plot*. For an extended discussion see http://www.b-eye-network.com/newsletters/ben/2468. ADVANTAGES: - less cluttered - better view of the data - great advantages when depicting *multiple groups of data* - better view for *Non-zero baseline* - *labeling* advantage when compared to the classic vertical bars of bar-charts See the pictures on the site and judge yourself (especially figures 4, and 5 and 6 are interesting).
reset to new
*** Issue 114687 has been marked as a duplicate of this issue. ***