Bug 96520 - XY plot: Allow more than 2 Y axes and more than 1 X axis
Summary: XY plot: Allow more than 2 Y axes and more than 1 X axis
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
 
Reported: 2015-12-15 19:28 UTC by Frederic Parrenin
Modified: 2022-01-14 18:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example .svg figure with many Y axes. (292.94 KB, image/svg+xml)
2015-12-15 19:28 UTC, Frederic Parrenin
Details
Example .svg figure with many axes (393.91 KB, image/svg+xml)
2015-12-16 21:08 UTC, Frederic Parrenin
Details
Another chart style with 3 Y axes (83.94 KB, image/jpeg)
2019-02-01 05:21 UTC, Mohith Manoj
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Frederic Parrenin 2015-12-15 19:28:03 UTC
Created attachment 121321 [details]
Example .svg figure with many Y axes.

Currently, Chart is limited since it does not allow to have more than two Y axes.
In scientific publications, it is very common to use charts with many Y axes.
I attach such example chart taken from an article published in the Science journal.
Comment 1 Jean-Baptiste Faure 2015-12-16 07:57:25 UTC
Valid enhancement request. Setting as NEW.
Note: setting an enhancement as NEW does not presume that some developer will work on its implementation.

Best regards. JBF
Comment 2 Frederic Parrenin 2015-12-16 14:11:35 UTC
Obviously one may want also to allow more than 1 X axis.
Changing title accordingly.
Comment 3 Jean-Baptiste Faure 2015-12-16 20:49:11 UTC
(In reply to Frederic Parrenin from comment #2)
> Obviously one may want also to allow more than 1 X axis.
> Changing title accordingly.

Please, could you attach an example of a chart with more than 1 x-axis and more than 2 y-axis.
If I look correctly your first example, it is a set of 3 charts where the 3 legends are grouped in one legend.

Best regards. JBF
Comment 4 Frederic Parrenin 2015-12-16 21:08:59 UTC
Created attachment 121355 [details]
Example .svg figure with many axes
Comment 5 Frederic Parrenin 2015-12-16 21:09:55 UTC
In my first example, the three charts are not independent since they share the same X axis.
As far as I know, it is not possible to do such a figure in LO Chart.
Now, I attach another figure with 5 Y axes and 2 X axes (the secondary X axis is not regular but that is another issue...).
Comment 6 Frederic Parrenin 2016-11-18 13:57:35 UTC
I was wondering if anybody is willing to work on that?
This is crucially needed before I can seriously use calc in my scientific field.
Comment 7 Frederic Parrenin 2018-02-23 16:40:47 UTC
This issue is still valid in LO 6.0.
It would be a strong selling argument for LO Calc with respect to MS Excel if such a feature was implemented (together with bug 96538).
I know many people which have to move their spreadsheet data to another more advanced graphing software because of this limitation.
Comment 8 Mohith Manoj 2019-02-01 05:21:58 UTC
Created attachment 148814 [details]
Another chart style with 3 Y axes

In this style the series are not stacked but share the same space (requires less height).
Comment 9 Frederic Parrenin 2020-10-17 16:42:43 UTC
As of 7.0, this feature is still not yet implemented.
Comment 10 Frederic Parrenin 2022-01-13 18:00:45 UTC
As of 7.2.5, this functionality has not yet been implemented.
Comment 11 Jean-Baptiste Faure 2022-01-13 23:20:29 UTC
Why did you do the summary lest precise than it was?

Best regards. JBF
Comment 12 Frederic Parrenin 2022-01-14 18:23:07 UTC
Because it is actually possible to have a secondary X-axis.
I am not sure if this is new or not, but the previous title is therefore wrong.