Bug 64160 - FORMATTING: Set scale on chart primary / secondary x-axes independently
Summary: FORMATTING: Set scale on chart primary / secondary x-axes independently
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
 
Reported: 2013-05-02 16:52 UTC by Nick
Modified: 2020-09-13 17:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
An example of a plot with different x-axes (380.95 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2013-05-02 16:52 UTC, Nick
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nick 2013-05-02 16:52:48 UTC
Created attachment 78787 [details]
An example of a plot with different x-axes

In Microsoft Office it is possible for users to create a plot with dual x-axes where each axis has a different scale. An example of how this is useful is for creating a differential pulse height spectrum where the bottom axis would have the channel number and the top axis has the energy. I'm sure there are many other situations in which this would be useful but I noticed that it is not possible to do in LibreOffice. I know it is possible to have dual axes but they must be the same, it would be great if a user could specify what each axis scale should be. I've attached a word document containing an example of the plot.
Comment 1 Owen Genat (retired) 2014-07-18 08:04:01 UTC
(In reply to comment #0)
> In Microsoft Office it is possible for users to create a plot with dual
> x-axes where each axis has a different scale.
> ...
> I know it is possible to have dual axes but they must be the same, 
> it would be great if a user could specify what each axis scale should be.

This seems like a reasonable request although it would appear to require further clarification as to whether this is possible under ODF v1.2 and what this means for interoperability (if Excel is already doing this). Would appear to either require:

(a) Setting a category child element in each X axis definition e.g. it is possible to have this:

<chart:axis chart:dimension="x" chart:name="primary-x" chart:style-name="ch4"/>
   <chartooo:date-scale/>
   <chart:categories table:cell-range-address="Sheet1.A2:Sheet1.A5"/>
</chart:axis>
<chart:axis chart:dimension="x" chart:name="secondary-x" chart:style-name="ch5"/>

... but having a separate chart:categories element for each X-axis would allow specifying independent values.

(b) Allowing data series to be attached to X-axes e.g., it is possible to have this for Y-axes:

<chart:series chart:attached-axis="primary-y" chart:style-name="ch9" chart:values-cell-range-address="Sheet1.B2:Sheet1.B5" chart:label-cell-address="Sheet1.B1:Sheet1.B1" chart:class="chart:bar">
   <chart:data-point chart:repeated="4"/>
</chart:series>
<chart:series chart:attached-axis="secondary-y" chart:style-name="ch10" chart:values-cell-range-address="Sheet1.C2:Sheet1.C5" chart:label-cell-address="Sheet1.C1:Sheet1.C1" chart:class="chart:bar">
   <chart:data-point chart:repeated="4"/>
</chart:series>

... which again allows separate ranges to be specified for the primary / second axes. I agree it would be great if the scales could be set independently. It would seem to be compatible with ODF v1.2 but this really needs to be determined by an expert. Confirmed. Status set to NEW. Component set to Chart. Platform set to All/All. Summary edited for clarity.
Comment 2 Regina Henschel 2020-09-13 17:08:31 UTC
The attached file uses linked data, which are not available. So it is not possible to see the underlying table. And it has a huge number of items. Can you please provide an example with embedded data with a small number of items, if possible as Excel file.