Issue 4770

Summary: offer a vertical x axis and horizontal value axis also for line charts (not only for bar charts) (allow swapping axes)
Product: General Reporter: moali <gerfried.maier>
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, tony.galmiche.ooo
Version: 3.3.0 or older (OOo)Keywords: rfe_eval_ok
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description moali 2002-05-12 22:03:56 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.
Comment 1 frank 2002-05-13 07:27:48 UTC
Hi Falko,

it seems to be one for you.

Frank
Comment 2 frank 2002-06-17 08:02:57 UTC
*** Issue 5894 has been marked as a duplicate of this issue. ***
Comment 3 frank 2002-06-17 12:06:12 UTC
*** Issue 5894 has been marked as a duplicate of this issue. ***
Comment 4 bigserpent 2003-09-10 06:45:32 UTC
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.

Comment 5 falko.tesch 2003-10-08 09:28:41 UTC
Re-assigned to Matthias Müller-Prove for further evaluation.
Comment 6 matthias.mueller-prove 2003-10-08 17:45:23 UTC
to Bettina, our central dispatcher for RFEs
Comment 7 bettina.haberer 2004-11-29 17:57:08 UTC
Reassigned to Björn.
Comment 8 bjoern.milcke 2005-01-28 17:09:13 UTC
->IHA: Sending you these issues so that all unconfirmed enhancements and
features are at one place.
Comment 9 eyalbens 2005-03-04 12:54:57 UTC
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).
Comment 10 IngridvdM 2005-03-04 17:30:01 UTC
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.
Comment 11 IngridvdM 2005-04-19 16:53:35 UTC
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.
Comment 12 bigserpent 2006-02-13 12:12:10 UTC
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.
Comment 13 IngridvdM 2006-02-13 13:12:10 UTC
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?
Comment 14 ace_dent 2006-02-15 11:37:11 UTC
*** Issue 62069 has been marked as a duplicate of this issue. ***
Comment 15 IngridvdM 2008-01-16 11:37:14 UTC
*** Issue 75725 has been marked as a duplicate of this issue. ***
Comment 16 IngridvdM 2008-01-16 11:40:41 UTC
Changed summary in hope to make this issue easier to find.
Adjusted Prio regarding votes and duplicates.
Comment 17 discoleo 2008-01-16 11:49:39 UTC
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).
Comment 18 IngridvdM 2008-07-22 14:21:17 UTC
reset to new
Comment 19 IngridvdM 2010-09-29 17:09:17 UTC
*** Issue 114687 has been marked as a duplicate of this issue. ***
Comment 20 kla 2010-11-24 08:49:14 UTC
*** Issue 114687 has been marked as a duplicate of this issue. ***