Apache OpenOffice (AOO) Bugzilla – Issue 86527
Secondary Y axis configurable length
Last modified: 2013-02-24 21:18:36 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).
Created attachment 51761 [details] Double Y axis example
Sorry, my fault. It can be already done by using personalized number formating for the axis, for example: [>2]"";0,00
closed as invalid