Issue 86527 - Secondary Y axis configurable length
Summary: Secondary Y axis configurable length
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-02-27 18:09 UTC by lamberete
Modified: 2013-02-24 21:18 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Double Y axis example (416.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-02-27 18:17 UTC, lamberete
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description lamberete 2008-02-27 18:09:02 UTC
***** THIS MIGHT BE A SPREADSHEET ENHANCEMENT INSTEAD OF A CHART ON *****

In a XY dispersion chart made with Calc, it is possible to refer the y data of
each serie to the primary (left) or secundary (right) Y axis.

It is also possible to edit both axis parameters as minimun and maximun values,
main interval....

But I believe it will also be great to be able to limit how much axis it is used
 , so just the lower part of the axis is drawed and filled with tags (for series
that just draw in the lower part of the chart).

For example. In the attached (see next message) euro-dollar-petrol.ods
spreadsheet, a chart has been made with two main series, the petrol price in
dollars (green one) and the petrol price in euros (blue one). This both are
refered to the left Y axis.

A third serie has been drawed (orange one), wich represents the euro-dolar coin
conversion that has been used for calculate the blue serie. This serie is
refered to the right Y axis, but just the first 4 tags of the right axis is
usefull, while the rest just create confusion when looking the chart.

I do not want to modify the maximun value of the right axis from 6 to 2 because
that will mix the orange line with the other two, but I want to keep them appart
because they represent very different things.

This scenario is often found in charts, like the weather ones, were left axys
represent the temperature and right one the ammount of rain, but just the needed
part of the right axis is drawed. (I couldn't find any chart on internet that
shows this, but I remember the ones that were on my school books and were that
way. Perhaps this kind of graphs on Internet are not naw that way because
there's no chance to do it with MSExcel or OOoCalc).
Comment 1 lamberete 2008-02-27 18:17:07 UTC
Created attachment 51761 [details]
Double Y axis example
Comment 2 lamberete 2008-02-29 18:18:09 UTC
Sorry, my fault.

It can be already done by using personalized number formating for the axis, for
example:

[>2]"";0,00
Comment 3 kla 2008-03-03 10:00:50 UTC
closed as invalid